SV: Basic SQL question

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