Search Results

Scott,

I tried using list command as below
sqlplus user/pwd@dbname << EOF
$(awk '{print $0"\nlist"}' inputfile.txt)
EOF

And this is printing the input query as well for each of the output...

Scott,
Thanks for the reply. Came to know about list command for the first time.:)
But i have a number of queries in the input file and i want to display the input query with corresponding output...

Hi Arkadia,

'set serveroutput on' helps in displaying the output. The probelm i'm facing is to display the input query which i'm passing from the text file and not with the output associated with...

Thanks for your immediate reply. I already tried settting echo ON. But this didn't help. The output still has only the output of the query without displaying the query.

Hi All,

I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below


sqlplus user/pwd@dbname << EOF...

> sed ''
Hello
hi
Hello output
How
hi output
^D
How
>
sed should take each line as input, process and output the result. In the above scenario the input is passed from keyboard and the...

nmap 10.226.112.222 | cut -d " " -f1 >file.txt
If you want service column to be printed you can use -f3 (3rd field)

Now i'm able to get valid results.
Thanks for your immediate replies.:)

Hi All,

I have a fixed-width datafile from which i need to extract value/string starting from some position to the specified length in each of the lines.

awk '{print substr($0,x,y)}' datafile...