E(A)lochana

ఆలోచనలకు ఈ రూపము ఇవ్వటమే ఈలోచన!!

Wednesday, May 28, 2014

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