How to test for Absence of Duplicate Tuples in a subquery in oracle
819390Dec 18 2010 — edited Dec 18 2010----------------------------------------------------------------------------------------
SQL> select * from customer
2 where unique (select * from dual);
where unique (select * from dual)
*
ERROR at line 2:
ORA-00936: missing expression
------------------------------------------------------------------------------------
unique construct is not working in oracle .
Now how to check Absence of Duplicate Tuples
Edited by: 816387 on Dec 18, 2010 9:23 PM