sql plus

[bsatheesh]

Hi , a small question. How will you see the scripts of stored procedure which has been created already.
Is it like

Select from user_objects?

thanks,
satheesh

[jmodic]

No, for source code of PL/SQL objects look at USER_SOURCE (ALL_SOURCE/DBA_SOURCE).

Something like:

SELECT text FROM dba_source
WHERE owner = 'USER_A' AND type = 'PROCEDURE' AND name = 'PROCEDURE_A'
ORDER BY line;

HTH,