Re: system stored procedures
Since 5.7, the sys database has quite a few sprocs & funcs, list them with ...
select routine_name, routine_type
from information_schema.routines
where routine_schema='sys';
... and eg show the source of the diagnostics sproc with ...
show create procedure sys.diagnostics\G
(watch out, it's huge)
Subject
Views
Written By
Posted
869
July 11, 2019 07:39AM
Re: system stored procedures
363
July 11, 2019 10:58AM
368
July 12, 2019 06:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.