Technical Blog

  Detailed phase of cursor execution  1. The cursor is opened  2. Parse SQL  3. The query is described to know the projection (w...

 A restore point is an attribute of a database, not a transaction, so you can generate many transactions and still restore the entire datab...

SAVEPOINT identify a point in a transaction to which you can later roll back. Example create table countries (region_id number,region_...

REF CURSOR Example create or replace package strongly_typed is     type return_cur is ref cursor return all_tables%rowtype;     proced...

SYS_REFCURSOR  Example create or replace function f return SYS_REFCURSOR as   c SYS_REFCURSOR; begin   open c for select empno  from em...