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

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

→      select  REPORT-TYPE  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,