Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I know the line number in a stored procedure?

Re: How do I know the line number in a stored procedure?

From: Rachel Rainey <raineyr_at_cuug.ab.ca>
Date: Tue, 23 Nov 1999 14:36:30 -0700
Message-ID: <383B08DE.6AA02419@cuug.ab.ca> 





I believe the columns are line and text,
so if you wish to display the proc, 


select line, text from user_source order by line;
of course, just do a desc on user_source to be sure these are the column
names



rtproffitt_at_my-deja.com wrote:


> 


> USER_/ALL_ SOURCE ?



> 


> Sent via Deja.com http://www.deja.com/


> Before you buy.


Received on Tue Nov 23 1999 - 15:36:30 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US