Oracle integrity constraints | Integrity Constraint - oracle tutorial - sql tutorial




What is Oracle Integrity Constraints ?

  • Integrity Constraints are used to prevent entry of invalid information into tables.
 data integrity constraint
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

There are five Integrity Constraints Available in Oracle. They are :

  • Integrity Constraints are used to prevent entry of invalid information into tables.
    • Not Null
    • Primary Key
    • Foreign Key
    • Check
    • Unique

Not Null:

  • A column in a table can be specified not null.
  • It's not possible to insert a null in such a column.
  • The default is null.

Primary Key:

  • Primary Key Constraint defines a column or combination of columns which uniquely identifies each row in the table.
  • After creating a primary key, it can be referenced by a foreign key

Foreign Key:

  • This constraint identifies any column referencing the PRIMARY KEY in another table.
  • It establishes a relationship between two columns in the same table or between different tables.
  • One or more columns can be defined as Foreign key.

Unique Key:

  • Unique Key Constraint ensures that a column or a group of columns in each row have a distinct value.
  • A column(s) can have a null value but the values cannot be duplicated

Check Key:

  • Check Key Constraint defines a business rule on a column.
  • All the rows must satisfy this rule.
  • The constraint can be applied for a single column or a group of columns.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to oracle integrity constraints | Integrity Constraint

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×