-
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 ??
siva prakash
DBA
-
Plase Ignore This Message .
siva prakash
DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|