Home » SQL & PL/SQL » SQL & PL/SQL » Line number in SQL
Line number in SQL [message #19233] Wed, 06 March 2002 08:01 Go to next message
uma
Messages: 67
Registered: May 2001
Member
I like to see the line numbers of SQL. How to print the line numbers for an existing written SQL or PROCEDURE. Is there any thing like "set autonum" something like that?.

Thanks,

Uma
Re: Line number in SQL [message #19241 is a reply to message #19233] Wed, 06 March 2002 11:06 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
I dont know what u are looking for..

try this:

set sqlnumber on
Re: Line number in SQL [message #19245 is a reply to message #19241] Wed, 06 March 2002 11:36 Go to previous messageGo to next message
uma
Messages: 67
Registered: May 2001
Member
I am looking for the line numbers of a SQL. For example I have SQL like this

Select sysdate from TABLE
where column1=value
and
column2=something

Then I want to see for this sql, line numbers like

1 Select sysdate from TABLE
2 where column1=value
3 and
4 column2=something

How to do this for any existing SQL?

Thanks and I hope you are clear. Sorry for confusion.

Uma
Re: Line number in SQL [message #19248 is a reply to message #19245] Wed, 06 March 2002 15:06 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use editor which provides that functionality
Re: Line number in SQL [message #19264 is a reply to message #19245] Thu, 07 March 2002 08:13 Go to previous message
uma
Messages: 67
Registered: May 2001
Member
Thanks. I got it.

Uma
Previous Topic: Closed Cursor query in procedure - listed in v$open_cursor
Next Topic: PL/Sqlplus-extracting data from Table to comma delim file
Goto Forum:
  


Current Time: Fri Mar 29 06:14:04 CDT 2024