Category: Tables

‘CREATE TABLE’ : create table with composite primary key

‘CREATE TABLE’ : sql create table command with composite primary key.CREATE TABLE statement can be used to create table objects in database. It is possible to add constraints like primary key ,foreign key while table creation.Primary key is the unique identifier for a row of data.

Oracle: ORA-02292: integrity constraint violated – child record found

‘ORA-02292: integrity constraint violated – child record found’ error occurs when we try to delete a row from a parent table which is having a child table with foreign key constraint and the corresponding data exists in the child table.