Re: Basic SQL question

David,

set sqlprompt "" sqlcontinue "" sqlnumber off

I think it's SQLNUMBER you want, but setting SQLPROMPT to "" will get rid of the "SQL> " as well.

Hope this helps...

-Tim

on 5/16/05 3:38 PM, David at thump_at_cosmiccooler.org wrote:

> 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
> 9 10 11 12 13 declare
> *
> ERROR at line 1:
> ORA-20224: ERROR!
> ORA-06512: at line 10
>
> Thanks in advance!

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