samedi 25 novembre 2017

IF ELSE statement inside another IF ELSE

I have part of my procedure something like this:

     declare 
         v_cnt_1  number;
         v_cnt_2 number;
    begin
        with input1  as(
        select .........
        from...
        where.....)
        select count(*) into v_cnt_1  
        from input1  t
        where......);

        with input2  as(
        select .........
        from...
        where.....)
        select count(*) into v_cnt_2 
        from input2  t
        where......);

       IF v_cnt_1 >0 or v_cnt_2 >0
      THEN DBMS_OUTPUT.PUT_LINE('all set');
      ELSE  DBMS_OUTPUT.PUT_LINE('take further action');
       end if;
       end;

my goal here is :if this query returns the result of 'take further action' then i have to implement other steps which if further if/else statement. I have four more situation(if/else) to add if this returns 'take further action'. how can i add if/else on the basis of this output? Or do i need to create another procedure and call this procedure inside new procedure?

Aucun commentaire:

Enregistrer un commentaire