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 MoreDeveloper's Guide
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 MoreSometimes 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 MoreWhen 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 MoreSometimes 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 MoreThere 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 MoreBeing 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