SQL owa_util.get_procedure and $$PLSQL_UNIT

In 10g and 11g I use the "owa_util.get_procedure" function. I normally use this in packages as it will also return the name of an internal procedure or function as part of the package name, i.e. (package_name).(procedure name). I use this to provide a generic EXCEPTION template for identifying where an exception occured. Source: https://stackoverflow.com/questions/286549/find-out-name-of-pl-sql-procedure#286569 Return... Continue Reading →

Oracle SQL: LAG Oracle 11g is analytic function

Very usefully new features in Oracle 11g is analytic Oracle SQL function LAG. SQL query LAG This code find change in address post code in journal table: Test query data SQL result site_number jn_datetime adr_postcode prev_adr_postcode 20001 2017-08-01 15:01:31 00-001 00-003 How it works together http://sqlfiddle.com/#!4/9a676b/1

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑