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.

 

 

→ select I click cascade delete

 

→ select voucher-number as foreign key column

 

→ Raak-trans-master reference table name

 

Voucher-number as reference table column list

 

→  NEXT FINISH

 

Equivalent sql script is as follows

 

"ALTER TABLE        "RAAK-TRANS-DETAIL"  ADD CONSTRAINT "RAAK-TRANS-DETAIL-FK1" FOREIGN KEY ("VOUCHER-NUMBER")                                        REFERENCES "RAAK-TRANS-MASTER" ("VOUCHER-NUMBER") ENABLE