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.

 

 

RAAK-TRANS-MASTER-UK1            against constraint name

→      select UNIQUE against constraint type

 

→      select VOUCHER-NUMBER against constraint on column

→      NEXT →       Finish

 

Equivalent SQL script

 

 

 

ALTER TABLE RAAK-TRANS-MASTER ADD CONSTRAINT

 

"RAAK-LEDGER-MASTER-UKl" UNIQUE ( "VOUCHER-NUMBER" )

 

 

 

 

 

16.04      HOW TO CREATE FOREIGN KEY CONSTRAINT

 

A foreign key means that values in one table must also appear in another table, The referenced table is called the parent table while the table with the foreign key  is called the child table, The foreign key in the child table will generally reference primary key in the parent