This content has been marked as final. Show 4 replies
Whenever you post provide your 4 digit Oracle version.
But I get "unsuported character set" error.
I don't see any posting of the EXACT exception and error message in what you posted.
I want to get the IDs of the passengers who have been registered more than once.
So why do extra work? Just query the IDs from the subquery
select ID from ( SELECT ID, COUNT(PASSPORTNO) FROM PASSENGERS GROUP BY ID HAVING COUNT(PASSPORTNO)>1)
I guess (logically) you should use <tt>'GROUP BY id'</tt> and not <tt>'GROUP BY passportno'</tt>
For the error you getting ,seems like some data is the issue.
Btw, are you getting any row as output of this query? To me this means there are multiple passports with same 'passportno' (which is not correct)
To check the exact data that is causing this issue, use <tt><b>DML Error Logging</b></tt> mechanism.
SELECT PASSPORTNO FROM PASSENGERS GROUP BY PASSPORTNO HAVING COUNT(*)>1;
Please mention your Oracle database version (use: select * from v$version )