what is alternative to sp_help in oracle

[2314]

Hi
how can i see the text of my stored procedure in oracle in sql server i use sp_help but it does not work in oracle

 

[HimanB]

Hi,
You can get your Stored Procedure & Functions's Text from view USER_SOURCE or DBA_SOURCE or ALL_SOURCE.

Select Text from user_source
where NAME ='MY_PROC';

HTH
Regards
Himanshu

 

[khobar]

Hi

I beleive sp_help can also be used on tables to describe the columns.

For procuedures use all_source

For table just desc <tname> in sqlplus


khobar