Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NEWBIE: how do I view a stored procedure from the command line?
Yes, in fact the column all_source.text contains the values aI was looking
for. Thank-you.
Gennaro Napolitano <Gennaro.Napolitano_at_sbsitalia.it> wrote in message
news:3741622D.2DE0C4D6_at_sbsitalia.it...
>
>
>Anonymous wrote:
>
>> Please help - I am having trouble with something simple... I've been
using
>> ORACLE for about a week now...
>>
>> <QUESTION>
>>
>> What is the syntax for viewing a stored procedure - from the command line
>>
>> </QUESTION>
>>
>> In other databases I can type "sp_helptext [procedure_name]" to view the
>> source of the stored procedure on the command line.
>>
>> Thanks I really do appreciate any information on this
>
>Try querying the system table 'USER_SOURCE'.
>
>Ciao Gennaro
>
>
Received on Fri May 21 1999 - 12:21:03 CDT
![]() |
![]() |