Could someone suggest the most CONCISE way to have SQL, NOT PL/SQL to verify that a value exist in a table and if the value exist, continue with the script, otherwise exit?

I know this is a simple matter in PL/SQL, but I'm curious of the method to do it in SQL.