Oracle Editor - Show Procedure / Package Details


select * from all_objects where object_type = 'PROCEDURE' AND OWNER = 'OWNER_NAME'

select * from all_objects where OWNER = 'OWNER_NAME'  ORDER BY 2

SELECT TEXT FROM USER_SOURCE WHERE NAME = 'PROCEDURE_NAME' ORDER BY Line;

Etiquetas: