If your database is on version 2020 SP1 (10.0.1) or above, you can skip this section.
-
Launch SQL*Plus and connect as M_SYS.
-
Perform the following commands:
ALTER TABLE m_questions
DROP CONSTRAINT qe_q_stage_chk
/
ALTER TABLE m_questions
ADD (CONSTRAINT qe_q_stage_chk CHECK ((qualification_stage IS NULL AND level1 IN ( 'TE','CE') ) OR
(qualification_stage IS NOT NULL AND level1 NOT IN ( 'TE','CE') )
OR qualification_stage IS NULL))
/