Hi,
Is there any way I can use Subquery in pl/sql function body returning error text? My condition is, I have to display only those customer records which does not exists in my target table through select list. My expectation is like this
if :P1_CUST_NM IN (SELECT cust_nm from customer) then
return 'Customer already exist!s!';
end if;
return null;
How can i do that? Really appreciated. Thanks
Vinish Kapoor
You can create a function to check if the supplied customer number exists or not. Below is an example:
Now you can use the above function as follows:
In SQL query: