/ Published in: PL/SQL
I often need to know if a record exists in a table. This method is probably the most efficient. Too many people don't use the exceptions that Oracle provides, which is a shame.
I think I got it from Tom Kyte's site? Or Steven Feuerstein?
I think I got it from Tom Kyte's site? Or Steven Feuerstein?
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
l_count PLS_INTEGER; INTO l_count FROM people END person_exists;