Re: Run a script at the OS command prompt

On Jul 3, 12:31 pm, Sashi <small..._at_gmail.com> wrote:
> On Jul 3, 12:48 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
>
>
> > On Jul 3, 10:38 am, Sashi <small..._at_gmail.com> wrote:
>
> > > > 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
> > > ----------
> > > ------------------------------------------------------------
> > > SITE_MGR_1
> > > ---------------------------------------------------------------------------ญญ-----
> > > SITE_MGR_2
> > > ---------------------------------------------------------------------------ญญ-----
> > > RECORD_CR RECORD_UP
> > > --------- ---------
> > > 2305 Site02592
>
> > > 07-MAY-07
>
> > > SITE_KEY SITE_ID
> > > ----------
> > > ------------------------------------------------------------
> > > SITE_MGR_1
> > > ---------------------------------------------------------------------------ญญ-----
> > > SITE_MGR_2
> > > ---------------------------------------------------------------------------ญญ-----
> > > RECORD_CR RECORD_UP
> > > --------- ---------
> > > 2306 Site02593
>
> > > 07-MAY-07
>
> > > ^C----------
> > > ------------------------------------------------------------
> > > 2307 Site02594
>
> > > 3058 rows selected.- Hide quoted text -
>
> > > - Show quoted text -
>
> > Reading the manuals would help tremendously:
>
> > set head off
>
> > Turns off the heading entirely.
>
> > set pagesize <some number here greater than 14>
>
> > Reduces the number of headers you get because you usually print them
> > at the top of a page.
>
> > set termout off
>
> > Turns off the terminal output when running a script. This is good for
> > dumping data to a file.
>
> > Again, this is ALL found in the documentation at:
>
> >http://tahiti.oracle.com
>
> > David Fitzjarrell
>
> Thanks, David.
> I will RTFM. I googled around for sqlplus options but didn't see
> these. I was expecting to be able to pass these options as flags to
> sqlplus and didn't realize that I needed to set the env vars.
>
> Regards,
> Sashi- Hide quoted text -
>
> - Show quoted text -

They're SQL*Plus parameters, not environment variables, and should be set in your .sql scrpt.

David Fitzjarrell Received on Tue Jul 03 2007 - 14:12:09 CDT