recent

Slow DELETE

10:38 PM
No one gets a maintenance window for days. The standard maintenance window is 4 hours or less for most companies. There are however applica...Read More

TNSPING Utility

12:02 PM
TNSPING is an Oracle utility to determine if the listener for a service on an oracle network can be reached successfully. This utility is lo...Read More

IN vs EXISTS

10:00 AM
You all may have used IN, NOT IN, EXISTS, and NOT EXISTS or have seen at one point in their IT career. Many believe SQL keyword IN is simila...Read More

Ref Cursor

10:00 AM
REF CURSORS is the powerful, flexible, and scale-able ways to return query results from Oracle database to application. It is a PL/SQL data ...Read More

Explicit Cursor

11:15 AM
A Cursor is a work area or a section of memory in which SQL statements are processed in the Oracle server. A cursor is a pointer to a privat...Read More
Powered by Blogger.