ORA-06531: Reference to uninitialized collection Error Description:Reference to uninitialized collection Error Cause:An element or member function of a nested table or varray was referenced (where an initialized collection is needed) without the collection having been initialized. Action:Initialize the collection with an appropriate... Read more
PLSQL collection data deletion CREATE OR REPLACE TYPE l_rec_type IS OBJECT (id NUMBER, name VARCHAR2 (1111)); / CREATE OR REPLACE TYPE l_tab_type IS TABLE OF l_rec_type; / Read more
Create two tables based on the query: insert into product values ('ashish',sysdate); / update product set message = 'Ashish Sahay' where current_date = sysdate; / Read more
Create user 12C: connect system/manager as sysdba alter session set "_ORACLE_SCRIPT"=true; / create user lime identified by limeoracle; / grant dba to lime; / connect lime/limeoracle / create table test(lime number); Read more
Sometimes whenever we want to insert records into table with the conditions For existing records (if found then) Update, For Non Existing records (If not found) then insert Step 1 : Create table a_merge as select empno , ename from... Read more
To refresh a Materialized view we need DBMS_SNAPSHOT.REFRESH procedure. Steps. CREATE TABLE demo_m ( id NUMBER (10) primary key, name VARCHAR2 (400) ); / INSERT INTO DEMO_M ( ID, NAME) VALUES (1001, 'VIKAS' ); / SELECT * FROM demo_m; One... Read more
Some times we do not know about our schema exist in which db and which is our schema hare is the method to find db and schema name. Result Schema Name:ASH_SCHEMA My DB Name:ORCL Read more
RANK() : function always returns sequential order for each record.DENSE_RANK() : It returns continuous order for each record. Read more
Many times we have faced the problem of trigger Mutating error. error ORA-04091: table TEST1.TEST_MUTATING is mutating, trigger/function may not see it let see how it comes and resolve CREATE TABLE test_mutating ( id NUMBER, name VARCHAR2(400 byte) ); INSERT... Read more