Re: how can I list procedure source

For all the stored procedures in the database SQL> desc all_source

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 LINE                            NOT NULL NUMBER
 TEXT                                     VARCHAR2(4000)

OR
Only for current user
SQL> desc user_source;

 Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 LINE                            NOT NULL NUMBER
 TEXT                                     VARCHAR2(4000)

select text from user_source where
order by name,line
Tom

John Dunn <JLDunn_at_ukgateway.net> wrote in message news:8l65o9$5ph$1_at_lure.pipex.net...
> how can i get the source of a pl/sql procedure or function, from sqlplus?
>
> John
>
>
Received on Thu Jul 20 2000 - 00:00:00 CDT