Re: Stored proc. and sqlplus

You select from USER_SOURCE, ALL_SOURCE or DBA_SOURCE, e.g.

select * from all_source
where type='PROCEDURE'
and owner like upper('&OWNER')
and name like upper('&NAME')
order by line

Ulf Grindstad <griulf_at_online.no> schrieb in Nachricht 36C00FCA.2D78B7D4_at_online.no...///
>How can I recieve the definition of an stored procedure in sqlplus ?
>Klaus
>
Received on Tue Feb 09 1999 - 08:25:35 CST