Toad World® Forums

Output column contains questions marks


#1

Hi,

when I query on tables in my database for some column in toad output column there is coming questions mark e.g., “???D” .

When same query is performed on SQL plus editor it is giving correct data.

Can any one please help to resolve this issue that why I am getting those questions mark in output column?

Thanks in Advance.


#2

Hi,

Please write us your database and TDM version you use. Thanks.


#3

You need to read the blogs on toad world about multi-byte data, national character sets and windows regional settings. This is a user config issue ….

From: user5431 [mailto:bounce-user5431@toadworld.com]

Sent: Thursday, November 07, 2013 9:23 PM

To: oracle@toadworld.com

Subject: [Toad World - Oracle Discussion Forum] Output column contains questions marks

Output column contains questions marks

Thread created by user5431

Hi,

when I query on tables in my database for some column in toad output column there is coming questions mark e.g., “???D” .

When same query is performed on SQL plus editor it is giving correct data.

Can any one please help to resolve this issue that why I am getting those questions mark in output column?

Thanks in Advance.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Oracle
notifications altogether.

Toad World - Oracle Discussion Forum

Flag
this post as spam/abuse.


#4

i have two separate query like this, but i need to make two separate column like sum(cd.item_pieces). on first query i am using

and nvl(cm.CONT_FINAL_AMT,0)>nvl(cm.CONT_PAID_AMT,0)

on second query i am using

and nvl(cm.CONT_FINAL_AMT,0)<=nvl(cm.CONT_PAID_AMT,0)

select

im.ITEM_CODE, wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, sum(cd.ITEM_PIECES), SUBSTR(wm.MODEL_NAME_ARB, 0, INSTR(wm.MODEL_NAME_ARB, ‘-’)-1), ww.current_balance

from

contract_details cd, contract_master cm , wh_model_master wm , wh_color_mast wc , wh_item_master im,COMP_BRANCH CB, wh_item_warehouses ww

where

cd.MODEL_NO =im.MODEL_NO

and im.item_code=ww.item_code

and cd.COLOR_CODE =im.COLOR_CODE

and cd.COLOR_CODE =wc.COLOR_CODE

and im.WOOD_CODE =im.WOOD_CODE

and cd.CONT_NO =cm.CONT_NO

and cd.MODEL_NO =wm.MODEL_NO

and cm.BRANCH_CODE=cb.BRANCH_CODE

and cd.MODEL_NO <>‘BDB0026’

and substr(wm.MODEL_NO,-4) =:m

and cd.ITEM_PIECES>NVL(cd.ITEM_DELV_PIECES,0)

and nvl(cm.CONT_FINAL_AMT,0)>nvl(cm.CONT_PAID_AMT,0)

and ww.wh_code = ‘WH50’

and ww.wh_code=NVL(:wh_CODE, ww.WH_CODE)

and cm.CONT_STATUS not in(‘DW’,‘DL’,‘CN’,‘SP’)

and cm.branch_code not in (‘11’,‘13’,‘15’,‘16’,‘17’,‘18’,‘20’,‘21’,‘22’,‘23’,‘24’)

group by im.ITEM_CODE,wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, ww.current_balance

ORDER BY wc.COLOR_NAME_ENG

select

im.ITEM_CODE, wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, sum(cd.ITEM_PIECES), SUBSTR(wm.MODEL_NAME_ARB, 0, INSTR(wm.MODEL_NAME_ARB, ‘-’)-1), ww.current_balance

from

contract_details cd, contract_master cm , wh_model_master wm , wh_color_mast wc , wh_item_master im,COMP_BRANCH CB, wh_item_warehouses ww

where

cd.MODEL_NO =im.MODEL_NO

and im.item_code=ww.item_code

and cd.COLOR_CODE =im.COLOR_CODE

and cd.COLOR_CODE =wc.COLOR_CODE

and im.WOOD_CODE =im.WOOD_CODE

and cd.CONT_NO =cm.CONT_NO

and cd.MODEL_NO =wm.MODEL_NO

and cm.BRANCH_CODE=cb.BRANCH_CODE

and cd.MODEL_NO <>‘BDB0026’

and substr(wm.MODEL_NO,-4) =:m

and cd.ITEM_PIECES>NVL(cd.ITEM_DELV_PIECES,0)

and nvl(cm.CONT_FINAL_AMT,0)<=nvl(cm.CONT_PAID_AMT,0)

and ww.wh_code = ‘WH50’

and ww.wh_code=NVL(:wh_CODE, ww.WH_CODE)

and cm.CONT_STATUS not in(‘DW’,‘DL’,‘CN’,‘SP’)

and cm.branch_code not in (‘11’,‘13’,‘15’,‘16’,‘17’,‘18’,‘20’,‘21’,‘22’,‘23’,‘24’)

group by im.ITEM_CODE,wm.MODEL_NAME_ARB,wc.COLOR_NAME_ENG, ww.current_balance

ORDER BY wc.COLOR_NAME_ENG