Format the output from sqlplus while writing to log file. Post: 302474268

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

File Format issue: Output of sqlplus

Hi, I am using a query like below in my shell script : { { echo "set echo off" echo "set head off" echo "whenever sqlerror exit -1; select NUMBER ||','|| FNAME ||','|| LOC ||','|| ...

2. Shell Programming and Scripting

sqlplus error output to different error log file

HELLO, I am using such a command to write oracle sqlplus query result to text file: sqlplus -S xxx/xxx@xxxxxxx @\tmp\2.sql>\tmp\123.txt Is it possible to script that: If command succesfull write in \tmp\log.txt: timestamp and "succeded" and create 123.txt with results else If error...

3. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has...

4. Shell Programming and Scripting

Log sqlplus output from Shell

UNIX Gods, I'll be running this script from CRON. I need to log the status of each of the six sqlplus calls into a file when this job is kicked off. Any suggestions? Thanks in advance. #!/bin/ksh export USAGE="USAGE: `basename $0` -e <DBUSER> <DBPASSWD> <TNSNAME>" if ; then ...

5. UNIX and Linux Applications

Please help: Oracle gqsql or sqlplus output format like mysql

On psql select titolo,lingua from titolo where titolo ~* 'brivid'; titolo | lingua ------- + ------ Brivido | 1 On Sqlplus/gqsql SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%'; TITOLO...

6. Shell Programming and Scripting

Writing the output of set -x into Log files

Hi Guys, I am using set -x in my script to track the flow of the script. But if i want to write the output of the set -x into a log file, how do i do it? Thanks, Ajay

7. Shell Programming and Scripting

Sqlplus inside shell script writing to tmp file

Hi, facing an issue while calling sqlplus inside shell script. It for some reason goes to tmp file to write something and i get error as permission denied as i dont have access there. ANy idea why sqlplus writes in /tmp and how to change or stop this ?

8. Shell Programming and Scripting

Writing output to a file in columns

Hi I am trying to write output to a file in columns I have file in the follwoing: # cat file abc def # I am trying to write next output as like # cat file abc 123 def 345 # :mad:

9. Shell Programming and Scripting

Getting output with sed without writing to a file

HI I am trying to grep 3 characters from hostname and append a character at the end. I tried as in the following: root@abag3:~# hostname | cut -c1-3 hyu Now I am trying to append "g" at the end of this output as in the following. root@abag3:~# hostname | cut -c1-3 | sed -s...

10. Shell Programming and Scripting

Wrong output when writing to file

Hello, I am having problem while redirecting output to a file where as on console output is proper. for dir in */; do printf "%s, " "$dir"; ls -m "$dir"; echo; done > output.txt Output of above command is coming in single line but when i am redirecting output to a file, single line i...

LEARN ABOUT DEBIAN

pytrainer

pytrainer(7)						 Miscellaneous Information Manual					      pytrainer(7)

NAME

       pytrainer - sport activity logging tool

SYNOPSIS

       pytrainer [options]

DESCRIPTION

       pytrainer  is  a  tool  to  log	all  sport  excursions	coming	from  GPS  devices  (with  a focus on ForeRunnner 205, 305 and 405) or GPX
       (http://www.topografix.com) files.
       Pytrainer supports GPS track files and displays it in graphs, maps...

OPTIONS

       -h, --help
	      show this help message and exit

       -d, --debug
	      enable logging at debug level

       -i, --info
	      enable logging at info level

       -w, --warn
	      enable logging at warning level

       --valid
	      enable validation of files imported by plugins (details at info or debug logging level) - note plugin must support validation

       --check
	      triggers database (only sqlite based) and configuration file sanity checks, adding fields if necessary. Backup of database  is  done
	      before any change. Details at info or debug logging level

       --oldgraph
	      Turn off new graphing approach

       --newgraph
	      Deprecated option: turn on new graphing approach

       --confdir=CONF_DIR
	      Specify the directory where application configuration will be stored.

       --logtype=TYPE
	      Specify where logging should be output to. TYPE is one of 'file' (default), or 'console'.

EXAMPLES

       pytrainer
	      starts pytrainer with log level set to ERROR

       pytrainer -d
	      starts pytrainer with log level set to DEBUG (troubleshooting)

AUTHORS

       This   manual   page  was  originally  written  by  Braulio  Valdivielso  <brlvldvlsmrtnz@gmail.com>  and  polished  by	Christian  Perrier
       <bubulle@debian.org>.

       For more information please check 'Credits' in 'About' menu.

       Thanks to everyone who contributes and supports pytrainer.

SEE ALSO

       Project web site: http://sourceforge.net/apps/trac/pytrainer/
       Distribution list: pytrainer-devel@lists.sourceforge.net

version 1.0							    2011-08-29							      pytrainer(7)