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

→

→

ObJect Browser

select Raak-Ledger-Master

→

→

Constraint       →      Create

change the default constraint name

as   RAAK-LEDGER-MASTER-CK2

against

constraint name

→      select Check against constraint type

→      select LEDGER-NAME  against constraint on column

→      IS NOT NULL in constraint expression window

→      NEXT →      Finish

Equivalent SQL script

ALTER TABLE RAAK-LEDGER-MASTER ADD CONSTRAINT "RAAK-LEDGER CHECK ( "LEDGER-NAME" IS NOT NULL )

To create ledger-code as uniqueness:

alter    table    raak-ledger-master    add      constraint raak-ledger-master-ukl unique (ledger-code);

To create ledger-name as uniqueness:

alter    table    raak-ledger-master    add      constraint raak-ledger-master-uk2 unique (ledger-name);