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.

 

 

action initiated, Hence we need to create the constraint as  follows

→      ObJect Browser under default table option

 

→      select Raak-Ledger-Master

 

→      Constraint       →      Create

 

→      change the default constraint name as

 

RAAK-LEDGER-MASTER-CKl          against constraint name

→      select Check against constraint type

 

→      selec REPORT-TYP against  constraint  on column

→      IN ( 'BS' , 'PL' ) in constraint expression

 

window

 

→      NEXT →      Finish

 

Equivalent SQL script

 

 

 

ALTER TABLE RAAK-LEDGER-MASTER ADD CONSTRAINT "RAAK-LEDGER

 

CHECK ( "REPORT-TYPE" IN ( IBSI ' IPLI ))

 

 

 

 

Another constraint Ledger-Name should be left blank or

 

NULL value is not permissible,