Hi,

In transact SQL u can use EXIST in this way

IF EXISTS(select * from my_table where my_field='my_value')
begin
...
end
ELSE
begin
...
end

If the select statement returns 1 or more rows the exists returns true otherwise false.

How can I do this same thing in Pl/Sql?
I thought I could do that with the exception but I am not sure.
Could u please tell me how can I do this?

Thank you very much
edli