SELECT * from v$access O WHERE o.type like ' procedure% '
Create materialized views and refresh periodically
Create materialized view Mv_name Refresh Force on demand start with Sysdate next Sysdate + 1
Create materialized view Mv_name Refresh Force on demand start with Sysdate next To_date (Concat (To_char (sysdate + 1, ' DD -mm-yyyy '), ' 22:00:00 '), ' dd-mm-yyyy hh24:mi:ss ')
GRANT SELECT on < table name or view name > to < user name >
GRANT <select/insert....>on < table or view name > to < user name >
--Create a sequence
CREATE SEQUENCE SEQ_MSS_GC_DDPH
MINVALUE 1
MAXVALUE 999999999999999999999999999
START with 1
INCREMENT by 1
NOCACHE ORDER;
--Create a trigger
CREATE OR REPLACE TRIGGER TRIGGER_MSS_GC_DDPH before INSERT on MSS_GC_DDPH
For each ROW
When (NEW. Ddphid is NULL)
BEGIN
SELECT SEQ_MSS_GC_DDPH. Nextval into:new. Ddphid from DUAL;
END;
Oracle query libraries already have stored procedures, create timed refresh views, role permission passes, create sequence triggers