exists

[abhaysk]

Originally posted by DaPi
Hi slimdave, I think I'd spend half a minute each time I saw that wondering what on earth it does! . . . and how do you deal with the ELSE ?

Else can be delt...but offcourse its not a good idea...

TEST:ABHAY> select * from TEST_EXISTS order by 1,2;

                  ID NAME
-------------------- --------------------
                   1 Abhay
                   1 Bhat
                   1 Raghu
                   2 Prasad
                   2 Vimal

TEST:ABHAY> Begin
  2  For X in ( Select 1 from TEST_EXISTS where ID=1 ) Loop
  3  DBMS_OUTPUT.PUT_LINE('1');
  4  End Loop;
  5  For X in ( Select 2 from TEST_EXISTS where ID not in (1) ) Loop
  6  DBMS_OUTPUT.PUT_LINE('2');
  7  End Loop;
  8  End;
  9  /
1
1
1
2
2

PL/SQL procedure successfully completed.

TEST:ABHAY>

Slimdave code can be formulated something like this

Begin
....

-- If Success Part of Your logic

   For X In (
             Select
                1
             From
                my_table
             Where
                my_field='my_value'
            )
   Loop
      ...
   End Loop;

-- Else part of your logic.

   For X In (
             Select
                1
             From
                my_table
             Where
                my_field NOT IN ('my_value')
            )
   Loop
      ...
   End Loop;

End;
/

Abhay.