DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...

  • Decode Vs Case
    Everything DECODE can do, CASE can. There is a lot more that you can do with CASE, though, which DECODE cannot. Differences between DECODE...
  • Bulk Bind in Oracle
    Bulk Bind or we can say FORALL in Oracle. The assigning of values to PL/SQL variables in SQL statements is called binding. The binding of ...
  • Collection Methods
    The following collection methods help generalize code, make collections easier to use, and make your applications easier to maintain: ...