I have a list of oracle queries and my goal is to merge them based on if condition where if output of select query is '0' then rest of the queries should execute else not.
My queries are as below:
-
First query of which output should be '0':
select pages from feature_control;
-
If output of above query is '0', then auto execute below three queries:
alter trigger feature_control disable;
alter trigger rep_feature_control disable;
update feature_control set pages = '0';
Aucun commentaire:
Enregistrer un commentaire