Thank u so much
A reader, June 24, 2017 - 6:26 am UTC
Allen Marshall, June 28, 2017 - 11:09 am UTC
Similarly, you can call those public procedures within a package from a standalone PL/SQL function in order to use those procedures in a SQL statement. The sp may be quite complex but if it returns a value of interest it can be wrapped with the function and used to incorporate the processing complexity in a SQL starement while generally speaking simplifying the statement radically.
June 29, 2017 - 1:58 am UTC
nice input