insert unique name into the table

[vikas sharmaa]

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.

[Avi Abrami]

Vikas,

select distinct NAME ...

Please refer to the Oracle documentation for more details.

Good Luck,
Avi.

[vikas sharmaa]

avi, distinct can be used in simple select sql query.

here if i use, distinct as below:

insert into Emp (empid, name, loc) select myseq.nextval, distinct name, loc from MyTable

it will give sql error.

[Campbell Ritchie]

You use distinct after "select." If you want the names to be unique (which is probably incorrect; there will be people with the same name as each other), you need to

Label the column UNIQUE when you create the table or

Use an ALTER TABLE names MODIFY COLUMN . . . instruction.