2 point is i need to remove the 1 value in the excel example if 12 is number i should table 2 only and need to find the emp table.
select empno from emp where empno in ( 2, 3, 4, 5, 6, . . );
968892 wrote:Excel data is not in a format that SQL*Loader can read.
or else .. simply load the excel data into temporary table using sql loader then check with data to emp table.