DECLARE
Mytime NUMBER (4, 2) :=9;

The BEGIN
IF mytime & gt; 23 THEN

Select *
The from YST0113
Where rownum<200;


The ELSE

Select *
The from YST0112
Where rownum<200;


END IF;
END;



Leave a great god, and of all stripes the PLSQL you will be prompted to error in the oracle database to perform, how can I change???
I first when mytime is equal to the different values, the output of different forms, such as more than 23 output table YST0113, the rest of the output table YST0112

CodePudding user response:

Select need the info to a variable, if there are multiple variables you need to use a cursor