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 ??