if exists replacement?
576808Jun 15 2007 — edited Jun 16 2007Hello,
I am looking for a way to do something like this in a procedure. Basically I want to verify that records exist in a table before doing a bunch of modifcations to those records. Since "if exists" isn't a valid pl/sql statement, I'm not sure how this sort of query is best performed?
if exists (select job from table1 where rownum < 2)
then
......
end if