troubleshooting Question
Oracle - ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
Wilder1626
asked on
asked on
Hello all
I have an error in the query bellow saying:
ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
How can i fix this?
The value i have in that column is a rate. I want to have the format 0.00
Thanks again for your help
I have an error in the query bellow saying:
ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
How can i fix this?
The value i have in that column is a rate. I want to have the format 0.00
Thanks again for your help
SELECT
'H',
'M',
ROW_NUMBER() OVER (ORDER BY TLR.CARRIER_ID) as ROW_NUM,
TLR.CARRIER_ID,
LRN.FROM_KEY_NUM,
LRN.FROM_LOW_KEY_VALUE,
CASE LRN.FROM_HIGH_KEY_VALUE
WHEN '0' THEN ''
ELSE LRN.FROM_HIGH_KEY_VALUE
END,
LRN.FROM_COUNTRY,
LRN.TO_KEY_NUM,
LRN.TO_LOW_KEY_VALUE,
CASE LRN.TO_HIGH_KEY_VALUE
WHEN '0' THEN ''
ELSE LRN.TO_HIGH_KEY_VALUE
END,
LRN.TO_COUNTRY,
CASE TRD.UNLOAD_MILE_RATE
WHEN '0' THEN ''
ELSE TO_CHAR(TRD.UNLOAD_MILE_RATE,'fm99999.00')
END,
TRD.MAX_STOPS
FROM
TL_RATE TLR, TL_RATE_DETAIL TRD, LANE_RATE_NETWORK LRN
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 8 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.