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.
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