Line number in SQL [message #19233] |
Wed, 06 March 2002 08:01 |
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 #19245 is a reply to message #19241] |
Wed, 06 March 2002 11:36 |
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
|
|
|
|
|