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!

ORA-12704: character set mismatch

924309Mar 21 2012 — edited Mar 21 2012
I have two tables like empday1,empday2

i need to find out the empday2 columns that are not existed in empday1 table.for this purpose i am using below query like:

select count(*) from(
select * from empday2
minus
select * from empday1)

but it showing error like below:
ORA-12704: character set mismatch

when i change query in like count(*) instead of * i am getting o/p as 0.that as of my understand all the columns in empday2 are in empday1.

but why it is showing character set error when i am using *.


please help me....


Cheers.....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2012
Added on Mar 21 2012
8 comments
3,853 views