Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

A check constraint requires a value in the database to comply with a specified condition,

 

16.01    How to create Primary

Key Constraint

 

In every table a row 1 record need to be identified by one unique column, That column value can be defined and Primary Key, Creating a table without primary key is not advisable since any record need to be identified by some value, The primary key of a relational table uniquely identifieeach record in the table, Ican either be a normal attribute that is guaranteed to be unique or it can be generated by the DBMS (such as a globally unique identifier, or GUID,   Primary  keys maconsist of a single attribute or multiple attributes in combination, Generally, the column declared as primary key will get populated from system generated sequence number, The various constraints will  be proposed in any database, wherein the primary key is one of the constraints,

→      ObJect Browse select   Tables  caption  under which select

→      RAAK-LEDGER-MASTER