Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting “ORA-01482: unsupported character set” when using WHERE IN pattern

MikailApr 20 2013 — edited Apr 20 2013
I have a table with the following structure in Oracle database:

CREATE TABLE PASSENGERS
*(ID VARCHAR2(6),*
PASSPORTNO VARCHAR2(14));

I want to get the IDs of the passengers who have been registered more than once. For that I run the following query.

SELECT ID FROM PASSENGERS WHERE PASSPORTNO IN
*(SELECT PASSPORTNO FROM PASSENGERS*
GROUP BY PASSPORTNO
HAVING COUNT()>1);*

But I get "unsuported character set" error. If I try to run the following queries separately I don't get any error:

SELECT PASSPORTNO FROM PASSENGERS
GROUP BY PASSPORTNO
HAVING COUNT()>1;*


SELECT COUNT(PASSPORTNO) FRO PASSENGERS;

SELECT ID FROM PASSENGERS;

What's the point I'm missing?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2013
Added on Apr 20 2013
4 comments
463 views