Fundamentals Archive

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

• Oracle Tables: Foreign Keys | Oracle Referential Integrity

  Foreign Key holds the reference to another table column value.It is also known as references constraint. A foreign key means...

  Read More

• Composite Primary Key in Oracle

  Composite primary key is a special type of primary key comprises a set of columns.In relational database a primary...

  Read More

• Oracle: Primary Key and Composite Primary Key

  In relational database a primary key is a candidate key to uniquely identify each row in a table. A unique...

  Read More

• Oracle/PLSQL: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/PLSQL: 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 statement: create a table with composite primary key

  CREATE TABLE statement: create a table with composite primary key.  

  Read More