Tables Archive

• Oracle ‘ALTER TABLE’ to ADD columns

  We can use the ‘ALTER TABLE’ statement in oracle to add columns to a table using ADD keyword.  

  Read More

• CREATE INDEX as part of CREATE TABLE statement.

  CREATE INDEX statement is used to create Indexes using table columns.An index allows faster retrieval of records.It is mainly...

  Read More

• Oracle Tables: Create Table as Select

  CREATE TABLE AS SELECT statement can be used when we need to extract part or full data from a...

  Read More

• Oracle Tables: Create table with foreign key constraint

  Usage Create table statement with foreign key constraint will create table with referential integrity. Foreign Key holds the reference to...

  Read More

• ‘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...

  Read More

• Oracle Tables:Create Table

  CREATE TABLE statement is used to create table objects in database.You can create tables with different column data types.It...

  Read More

• Oracle Tables: CREATE TABLE statement: create a table with primary key.

  Oracle Tables: CREATE TABLE statement: create a table with primary key.  

  Read More

• Oracle Tables: Foreign Keys with ON DELETE CASCADE option

  Oracle Tables: Foreign Keys with ON DELETE CASCADE option.Foreign Keys with ON DELETE CASCADE option allows us to create...

  Read More

• Oracle: ORA-02449: unique/primary keys in table referenced by foreign keys

  Oracle: ORA-02449: unique/primary keys in table referenced by foreign keys  

  Read More

• 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...

  Read More