strange ORA-01789: query block has incorrect number of result columns
Hi friends ,
i have simple sqlplus command which is giving some strange error message.
can anyone please suggest if i am missing anything here .
select grp_id
from SCORE_HSB0243S_BKP where grp_id not in (-11512,-9850,-9845,-9816,-9815,-8388,-7493,-7492,-7265,-7264,-7263,-7262,-7261,-7260,2097970,2241910,2241911,2241912,2241913,2241914,2241915,2241916,2241917,2241918,2241919,2241920 ,2241921,2361998,2795234,2795235,3607596,3636481)
minus
select grp_id from SCORE_HSB0243S where grp_id not in (-11512,-9850,-9845,-9816,-9815,-8388,-7493,-7492,-7265,-7264,-7263,-7262,-7261,-7260,2097970,2241910,2241911,2241912,2241913,2241914,2241915,2241916,2241917,2241918,2241919,2241920 ,2241921,2361998,2795234,2795235,3607596,3636481)
gives below error message
ORA-01789: query block has incorrect number of result columns
but if i replace column name with * it works ??