How do you do an IF EXISTS
446249Aug 11 2005 — edited Jun 28 2010Hi, all. I'm new to the Oracle world, coming from the SQL Server world. I'm trying to do something like this,
if exists (select * from mytable where id = 12345) begin
-- do some processing on existing record
end
else begin
-- do some other processing
end
The only places I've seen EXISTS is in the WHERE clauses. Help!