Answers for "pl sql constraint user function"

SQL
0

pl sql constraint user function

ALTER TABLE tbl_AccountAuthentications ADD (fnCheck NUMBER GENERATED ALWAYS AS (fnCheckValid(accountid_fk)) VIRTUAL);


ALTER TABLE tbl_AccountAuthentications
ADD CONSTRAINT chkCheckvalid CHECK(fnCheck <= 1);
Posted by: Guest on October-10-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language