TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

Oracle

Oracle Integrity Constraints

Overview

Oracle Integrity constraints are set to Oracle database tables and columns. There are several constraints that we can apply to set conditions or to limit the range of values ​​for database objects.

Types of constraints

Some of the constraints are as follows:

  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • CHECK
  • ON DELETE CASCADE

NOT NULL

NOT NULL constraint – The database table column must always be filled with a value.

UNIQUE

UNIQUE constraint – The database table column or combination of columns should be is unique.

PRIMARY KEY

PRIMARY KEY constraint – To indicate that the database table column or combination of columns is the primary key for the table.

FOREIGN KEY

FOREIGN KEY constraint – database table column or column combination must exist as a key in a separate database table.

CHECK

CHECK constraint – Boolean expression is true

ON DELETE CASCADE

ON DELETE CASCADE constraint – Deleting a data row leads to the cascading deletion of the data rows in another database table connected via the FOREIGN KEY constraint.

 

—

Oracle Database Tutorials on this website:

https://www.testingdocs.com/oracle-database-tutorials-for-beginners/

More information about Oracle Database:

https://www.oracle.com/database/

Related Posts

Download SQL Developer

Oracle /

Download Oracle SQL Developer

Oracle Databse 19c Download

Oracle /

Install Oracle 19c Database On Windows 10

ORA-01109 Database Not Open

Oracle /

Fix ORA-01109: database not open Error

Oracle SQL Update Statement

Oracle /

Oracle SQL Update Statement

Oracle SQL Insert Statement

Oracle /

Oracle SQL INSERT Statement

› Setting Up Sample Schema in Oracle

Recent Posts

  • MS Access Data Types
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version