Check out example codes for "oracle show procedures". It will help you in understanding the concepts better.

Code Example 1

-- Specifically for SQL:Oracle

SELECT * 
FROM ALL_PROCEDURES;

Learn ReactJs, React Native from akashmittal.com