Create table with compute column. Create table Demo ( min_sal int, max_sal int, Myavg_sal as (min_sal+ max_sal)/2 )
The example below uses a ref cursor to return a subset of the records in the EMP table. The following procedure opens a query using a SYS_REFCURSOR output parameter. Notice the cursor is not closed in the procedure. It is up to the calling code to manage the cursor once it has been opened. CREATE OR REPLACE PROCEDURE… Read More »
During large transactions involving multiple dependancies it is often difficult to process data efficiently due to the restrictions imposed by the constraints. An example of this would be the update of a primary key (PK) which is referenced by foreign keys (FK). The primary key columns cannot be updated as this would orphan the dependant tables, and the… Read More »
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!