Re: SV: Basic SQL question

From: David <thump_at_cosmiccooler.org>
Date: Mon, 16 May 2005 14:48:39 -0700 (PDT)
Message-ID: <40711.127.0.0.1.1116280119.squirrel@www.cosmiccooler.org>

#!/bin/csh

sqlplus / <<EOF
QUERY
eof

Running script at os command line as ./script.sh

-- 
..
David



> How do you start your job?

>

> Sqlplus scott/tiger << eof

> Select *

>>From xx

> where ...;

> exit

> EOF

>

> An alternative:

> Sqlplus scott/tiger @x

>

> Regards

> Karsten Weikop

>

> -----Oprindelig meddelelse-----

> Fra: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]

> P=E5

> vegne af David

> Sendt: 16. maj 2005 23:39

> Til: oracle-l_at_freelists.org

> Emne: Basic SQL question

>

> Can anyone tell me how to get rid of these line numbers fromr the output

> of a job:

> Connected to:

> Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production

> With the Partitioning, OLAP and Oracle Data Mining options

> JServer Release 9.2.0.5.0 - Production

>

> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>   2    3    4    5    6    7

> 8=20

>   9   10   11   12   13  declare

> *

> ERROR at line 1:

> ORA-20224: ERROR!

> ORA-06512: at line 10

>

> Thanks ion advance!

> --=20

> ..

> David

> --

> http://www.freelists.org/webpage/oracle-l

>

>

> --

> http://www.freelists.org/webpage/oracle-l

>


--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 16 2005 - 17:53:15 CDT