Subscribe SQL & PLSQL Tips via email
Globinch is a Technology Blog .More
| Search Globinch plsql world: |
-
Oracle Tables: CREATE TABLE statement: create a table with primary key.
Oracle Tables: CREATE TABLE statement: create a table with primary key. -
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... -
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... -
Oracle: ORA-02449: unique/primary keys in table referenced by foreign keys
Oracle: ORA-02449: unique/primary keys in table referenced by foreign keys -
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... -
ORA-02291: integrity constraint violated – parent key not found
ORA-02291: integrity constraint violated – parent key not found error occurs when we try to insert a row in... -
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... -
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... -
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... -
Oracle: SQL MIN Function | MIN() function in SQL
The MIN function returns the minimum value of an expression.MIN() function is reverse of MAX() function.MIN() function can be...
-
Constraints
Oracle Tables: CREATE TABLE statement: create a table with primary key.
No Comments -
Fundamentals
Oracle Tables:Create Table
9 Comments -
Constraints
Oracle Tables: Foreign Keys with ON DELETE CASCADE option
2 Comments -
Constraints
Oracle: ORA-02449: unique/primary keys in table referenced by foreign keys
1 Comment -
Constraints
Oracle: ORA-02292: integrity constraint violated – child record found
1 Comment -
Error Codes
ORA-02291: integrity constraint violated – parent key not found
3 Comments -
Constraints
Oracle Tables: Foreign Keys | Oracle Referential Integrity
5 Comments -
Constraints
Composite Primary Key in Oracle
4 Comments -
Constraints
Oracle: Primary Key and Composite Primary Key
3 Comments -
Functions
Oracle: SQL MIN Function | MIN() function in SQL
1 Comment