Debugging PL/SQL Code: Stepping through code is a basic necessity for programmers to test and verify logic flow in code. Very few PL/SQL programmers use this capability. Most, if not all, rely on the capabilities of the Oracle supplied package DBMS_OUPUT. Specifically, the PUT_LINE procedure within DBMS_OUTPUT is used as a crutch for debugging needs. … Continue reading Oracle – Capture PL/SQL Output From DBMS_OUTPUT.PUT_LINE To Table Or File
Oracle's logical storage structures: To developers who work with Oracle, the concept of tablespace is familiar. We create tables and indexes in tablespaces taking appropriate care not to place all of our data into one tablespace. Let us take a quick look at the logical structure of an Oracle database A database has one or … Continue reading Oracle’s APPEND Hint – The Key Secret To Fast BULK Loading With NOLOGGING!
Thanks to everyone who attended my "Instrument your code - Basic TSQL Logging" presentation. The material accompanying the presentation is available for download here: https://onedrive.live.com/?id=74472AED60B210DA%211183&cid=74472AED60B210DA The source code is open-source and the community is encouraged to enhance and update. The Github home for it is https://github.com/SQLJana/TSQL_Logger Feel free to experiment with the code and post feedback/comments and file … Continue reading “Instrument your code – Basic TSQL Logging” presentation
Update (Jan 18, 2017): I was able to add “autonomous transaction” type support to the logger using the means available in SQL Server (a loopback linked server). The new and updated code is available on GitHub. https://github.com/SQLJana/TSQL_Logger ....main post continues below Logging is one of those things no two people can agree on one way … Continue reading SQL Server – TSQL Code Logging To Table