CASE is not used for flow control (like IF-ELSE) in Oracle SQL. To perform the desired operation (insert records if they exist, or insert a default value otherwise), you must use a combination of PL/SQL or separate SQL statements with IF or MERGE.