03-17-2015
sqlplus has various format options which can generate almost anything format wise.
Check out this document :
Formatting SQL*Plus Reports
Have you tried some options it provides ?
Regards
Peasant.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
My requirement is :
We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this.
Can you please share a code snippet which... (4 Replies)
Discussion started by: venkatesh_sasi
4 Replies
2. Shell Programming and Scripting
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies
3. UNIX for Advanced & Expert Users
Hello Guys,
This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help.
Here is my script-
#! /bin/ksh
export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
/opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Discussion started by: thepurple
5 Replies
4. Programming
I know little SQL and could really use a hand here. I need to get the fields last_name, first_name and email from the table users and only if the entery with the same pkey in the table addresses, in the city column is Seattle.
So if the city in the addresses table is Seattle, go to the table... (2 Replies)
Discussion started by: computethis
2 Replies
5. Shell Programming and Scripting
Hi,
my sql query return below value for " $SQL_OPN_AMT "
CUSTCODE OH OHOPNAMT_GL OHREFNUM -------------------------------- -- ----------- ------------------------------ OHENTDATE FCC --------- --- 1.1072256 IN 74.85 000072061
0 01-MAY-13 MVR 1.1072256 IN 751.72 0000744751 01-JUN-13 MVR... (3 Replies)
Discussion started by: ranabhavish
3 Replies
6. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
7. Shell Programming and Scripting
#! /bin/ksh
#] && . ./.profile 2>/dev/null
if test -f '.profile'; then . ./.profile; fi;
#. .profile
LOG_DIR=/app/rpx/jobs/scripts/just/logs
sendEmail()
{
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
(
... (21 Replies)
Discussion started by: ankit.mca.aaidu
21 Replies
8. Shell Programming and Scripting
Hi
iam new to shell scripting
how to declare variables as redshift query and I have to compare two counts by using if condition .
ex:count=select count(*) from prd;
select count(*) from prd;
select count(*) from tag;
can any one help me .
Please use CODE tags when displaying... (1 Reply)
Discussion started by: sam526
1 Replies
9. Shell Programming and Scripting
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
10. Shell Programming and Scripting
Hi Team,
below sql rerturn 20 records, the result set i am going to assign to one variable and it showing count is 1.
and i don't use count() in sql query... based on count, i need to fail the script.
No_of_step=`echo ${g_count} | wc -l`
function gf_count()
{
g_count=`sqlplus -s... (8 Replies)
Discussion started by: bmk123
8 Replies
LEARN ABOUT REDHAT
makekdedoc
MAKEKDEDOC(1) KDOC Documentation System MAKEKDEDOC(1)
NAME
makekdedoc -- Generates HTML documentation for KDE libraries using KDOC.
SYNOPSIS
makekdedoc [--rule-file=<rulefile>] [--libdir=<libdir>]
[--outputdir=<outputdir>] [--url=<url>]
[--srcdir=<kdelibs src dir>]
[--kdoc=<path to kdoc>] [<library>...]
makekdedoc --help
DESCRIPTION
This is a perl script that uses KDOC to generate documentation for kdelibs. A "rule" file is used to figure out the libraries to document,
the order in which to document them and the libraries with which each one will be cross-referenced (eg kdeui uses -lkdecore). See "FILES"
for more info.
NOTE: The script assumes that you have already generated a Qt cross-reference using qt2kdoc[1].
OPTIONS
Defaults for each option are in square brackets.
library...
Specify the libraries to document. By default, all libraries defined by the rule file are documented.
--outputdir <path>, -d <path>
The directory where the output will be written. [`cwd`/srcdoc]
--url <url>, -u <url>
The base URL by which the generated docs will be accessed. For example, if your web server is configured to use $HOME/public_html for
your home page, you could set the outputdir to $HOME/public_html/srcdoc and the url to http://myhost/~mylogin/srcdoc. [output dir]
--rule-file <path>, -r <path>
The path to the rule file to use for generating the documentation. [<srcdir>/kdoc.rules]
--libdir <path>, -L <path>
The directory in which the KDOC cross-reference files are stored. [$KDOCLIBS if set, otherwise $HOME/.kdoc]
--kdoc <path>, -k <path>
The path to the kdoc program. [kdoc]
--kdocopt <options>, -p <options>
Extra options to be passed to kdoc.
--srcdir <path>, -b <path>
The path to the kdelibs source, eg "$HOME/baseline/kdelibs". [`cwd`]
--help, -h
Quit with a usage message.
EXAMPLES
makekdedoc --srcdir $HOME/baseline/kdelibs
--outputdir $HOME/public_html/src/kdelibs/
--url "http://www.ph.unimelb.edu.au/~ssk/src/kdelibs"
FILES
Rule file
This file lists the directories in the source directory to document. It also lists the files to document from each directory, and the
libraries with which to cross-reference the generated documentation. Here is a small example that documents two libraries and links the
second to the first.
# makekdedoc rule file
doc_MODULES = eenie meenie
# rules for eenie
eenie_FILES = *.h
eenie_LIBS = -lqt
# rules for meenie
meenie_FILES = a.h b.h
meenie_LIBS = -leenie -lqt
In this example, all files in "eenie/*.h" will be documented then two files from "meenie/" will be documented, in the order declared in
"doc_MODULES".
SEE ALSO
See kdoc[1] and qt2kdoc[1].
VERSION
makekdedoc $Revision: 1.2 $
AUTHOR
The script and this documentation were written by Sirtaj Singh Kang <taj@kde.org> in April 1999.
2.0a54 2000-10-10 MAKEKDEDOC(1)