Hi i am using shell script which perform oracle database query and after that output is redirect to some temporary file.

the output of this file looks like
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 5 16:08:06 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>
HOUR COUNT(*)
---------- ----------
11 30
12 12
15 11

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

Now in fact i want to extract the columns data HOUR and COUNT(*) .Then how can i extract or grep this columns from this temporary file.
any help ..

//regards
sunil

Something like this should work:

awk '/HOUR COUNT/{f=1}f' file

Use -B option with grep. like,

To print below 5 lines of search pattern,

grep -B 5 "HOUR COUNT" filename

---------- ---------- 11 30 12 12 15 11

in first one when i give below command

#awk '/HOUR COUNT/{f=1}f' <filename>

result::
awk: syntax error near line 1
awk: bailing out near line 1

i dnt know size of column it can be n number in size
for currentr case it is giving me below response.
grep: illegal option -- B
Usage: grep -hblcnsviw pattern file . . .

Use nawk or /usr/xpg4/bin/awk on Solaris.

Regards

Couldn't you just run sqlplus with the -silent option in the first place?

Great era,
Thanks i was not aware of -silent feature of sqlplus ..

now without greping i got my desire output.

//Regards
Sunil Goyal