| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Preferred way to check a record exists
What's the preferred way to check whether a record actually exists in a
table? If I wanted to check whether author is listed, is it naive to do
something like this, or it better to catch the NO_DATA_FOUND exception?
Maybe there's another approach altogether...
SELECT COUNT (*)
INTO v_count
FROM People
WHERE AddAuthor.address = Address
AND author = Name;
IF v_count = 1 THEN
DBMS_OUTPUT.PUT_LINE (author || ' in ' || AddAuthor.address ||
' was found in the database, now registering as an author ...
');
ELSE
DBMS_OUTPUT.PUT_LINE (author || ' in ' || AddAuthor.address ||
' not found');
Received on Wed Sep 17 2003 - 07:44:45 CDT
![]() |
![]() |