Hi,
I was trying to select a distinct column and insert the result set in a new table with a sequence. Below is the code
insert into tableA values(colA_PK, colA_1)
select colA_PK_sequence.nextval, distinct(colB_1) from tableB where colB_2=xCriteria;
This one throws me a ORA-00936 error. Is it possible to use both the sequence and distinct in the same statement. If Yes, can you please provide me the syntax
Thanks in advance for your help.