create or replace view
PROC_ERROR
as
select *
from USER_ERRORS
proc_list.sql
create or replace view
PROC_LIST
as
select OBJECT_NAME as "プロシージャ名"
,STATUS as "状態"
,OBJECT_TYPE as "タイプ"
,CREATED as "作成日"
,LAST_DDL_TIME as "更新日"
from USER_OBJECTS
where OBJECT_TYPE in ('FUNCTION','PROCEDURE')
proc_text.sql
create or replace view
PROC_TEXT
as
select * from USER_SOURCE