[오라클] sql plus에서 프로시저를 확인하고 싶을때..

SQL>set long 100000

SQL>select * from user_objects where object_type = ‘PROCEDURE’;

SQL>select text from user_source where name = upper(‘프로시져명’);