| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Run a script at the OS command prompt
> Go to Morgan's Library atwww.psoug.org.
> Scroll down to UNIX/vi
> Scroll down to SQL*Plus Shell Script Demo
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
> Go to Morgan's Library atwww.psoug.org.
> Scroll down to UNIX/vi
> Scroll down to SQL*Plus Shell Script Demo
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
OK. A here document is a good idea and it should work.
But my output is still the same:
Each record of the output is preceded by the column headings. I can
clean it up inside vim or use awk/sed etc but that just doesn't seem
right.
Why is this happening? Please see my sample output below.
As you can see, my record structure has 5 columns. Every output record
has the column headings.
How do I avoid this?
SITE_KEY SITE_ID
2305 Site02592
07-MAY-07 SITE_KEY SITE_ID
2306 Site02593
07-MAY-07 ^C----------
2307 Site02594
3058 rows selected. Received on Tue Jul 03 2007 - 10:38:41 CDT
 |
 |