How to turn a list of string literals into a table in Oracle and compare with other table to find missing entries
select column_value as EmpNum
from table(sys.odcivarchar2list('101', '102', '103', '404', '605'))minus
select EmpNum
from
EmployeeTbl;
0 Comments:
Post a Comment
<< Home