Tips

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE in PLSQL

In Big/complex applications, it is essential to call Sub-programs (Procedures/Functions) from other sub-programs. In that case it will be difficult to trace out Errors/Exceptions from where it is raised i.e. which sub-program caused the exception. Normally we can use SQLCODE and SQLERRM to get the error/exception, but these may not work in the above case. …

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE in PLSQL Read More »

Toad and SQL Developer shortcuts for Database Developers

S.No. Shortcut Functionality Toad SQL Developer 1 Ctrl + Enter Ctrl + Enter Executing Query or selected script (multiple queries execution is not available in Toad) 2 F9 F9 Executing Query or selected script (multiple queries execution is not available in Toad) 3 F4 Shift + F4 Viewing Object properties i.e. Code of Functions/Packages/procedures and …

Toad and SQL Developer shortcuts for Database Developers Read More »

Scroll to Top
small_c_popup.png

We're Hiring

join Us

We’re looking for passionate Lead Content writer & Graphic designer.