i've an Emp table with empid, name, and loc columns. now, in
java, query is written to insert records into Emp table from MyTable as follows:
insert into Emp (empid, name, loc) select myseq.nextval, name, loc from MyTable
in MyTable table, there are duplicate records for name column. So, those duplicate name are getting inserted into the Emp table.
how could i modify the query to insert unique name into the Emp table.