Using "where rownum = 1" at the end of your query will cut down your work a bit. If whatever exists, there is at least one, and there will be one with rownum equal to one.
You have to do the select or count somewhere along the line to find out if you have any.




Reply With Quote