9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
2. UNIX for Dummies Questions & Answers
Hi -- Working on my own through the book "Learning the KornShell and came to task 4-1, which there is:
a script "highest" and it will sort an "album" file.
highest filename
The author mentions adding a header line to the scripts output if the user types in the -h option. It says "assume the... (9 Replies)
Discussion started by: Decoy Octopus88
9 Replies
3. Shell Programming and Scripting
Hello There...
I have a sample input file ..
number:department:amount
125:Market:125.23
126:Hardware store:434.95
127:Video store:7.45
128:Book store:14.32
129:Gasolline:16.10
I will be doing some manipulations on all the records except the header, but the header should always be... (2 Replies)
Discussion started by: juzz4fun
2 Replies
4. Shell Programming and Scripting
i have the SQL as mentioned below.
i put this sql in a file and calling from the script and output of SQL
has been redirected to a file.
but when i open the sql output file i dont see the header in sql output.
how can i get the header also ?
====
SELECT RATE_CODE,NAME, CTR,TYPE
... (1 Reply)
Discussion started by: mail2sant
1 Replies
5. Shell Programming and Scripting
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies
6. Shell Programming and Scripting
I have a Script that generates 3 columns of the result. The line script is
/usr/xpg4/bin/awk -F' ' '{print $1 /t $2}' File_Name | awk -F'>' '{print $2}' | cut -d'<' -f1 | sort -rn | uniq -c
The output of the Command is :
Code.500 4 Input Error
Code.404 ... (4 Replies)
Discussion started by: raghunsi
4 Replies
7. Shell Programming and Scripting
hi,
I want to extract and save the cpu(s) information from top command output, but individual cpu statistics separately on a multi-processor machine.
In command line, top will show this statistics when we press the switch "1".
any ideas?
thanks,
meharo (3 Replies)
Discussion started by: meharo
3 Replies
8. Shell Programming and Scripting
i have a script that access the database and then returns some row. but in the command prompt it it not showing the column header. how to get that ?
below the script:
------------------------------------------------------------------------
#!/bin/ksh
.... (4 Replies)
Discussion started by: ali560045
4 Replies
9. Shell Programming and Scripting
i have this script here..
text=/d:/...../1.txt
ORACLE_HOME/bin/sqlplus -S............
...................................................
spool $text;
select
item || '|' ||
ord_no || '|' ||
price || '|' ||
from order_table
The output header of this spooled data will be ... (4 Replies)
Discussion started by: forevercalz
4 Replies