Technical Blog

To get the locks on an object SELECT oracle_username USERNAME,owner OBJECT_OWNER,object_name, object_type, s.osuser,s.SID SID,s.SERIAL# SE...

Check Constraint CREATE TABLE EMP_DETAILS( NAME VARCHAR2(20), MARITAL CHAR(1) CHECK(MARITAL='S' OR MARITAL = 'M'), CHIL...

PRIMARY KEY LOOK UP DURING FOREIGN KEY CREATION The lookup of matching primary keys at time of foreign key insertion takes time.In realea...

Everything (Table Creation including Primary ,Foreign key ,Check constraint and giving user defined CONSTRAINT NAME for NOT NULL CONSTRAINT...