How To Tag a Particular Query
Sometimes it happens that you want to track and trace your query or block of code in the Shared SQL area (v$sql) or v$session. For this particular purpose, Oracle is …
How To Tag a Particular Query Read MorePL/SQL Tips&Tricks
Schema DDL Audit
Sometimes you might need to check who is messing up with your DB 🙂 You can either turn on the AUDIT TRAIL or, if you are crafty, you might wanna …
Schema DDL Audit Read MoreParsing Results Of Dynamically Built SELECT Query
When you want (from whatever reason) parse data coming from dynamically built SELECT query you have to use EXECUTE IMMEDIATE and BULK COLLECT together with collections and records. See the …
Parsing Results Of Dynamically Built SELECT Query Read MoreRecords As OUT Parameters
Sometimes it’s not only a single value we need to return but a whole set of data. In this case, it might be handy to return the data set as …
Records As OUT Parameters Read MoreBlock Connection From Excel To Oracle
There might be several reasons why you want to block a connection to a database from excel files. It might not be only the Excel but other programs as well. …
Block Connection From Excel To Oracle Read MoreLogging Package
Being able to properly log all details about your processes is essential with regard to backtracking of issues or tuning the performance. With a proper log, you can easily see …
Logging Package Read More