| Data Type Mismatch [message #183890] |
Mon, 24 July 2006 04:54  |
bagulia_pilla
Messages: 25
Registered: July 2006
|
Junior Member |
|
|
Please help me for this condition.
I need to know if there is any data type mismatch.
Plz send me all the details since I need to
[COD]
what will be performance Issue when data type mismatch
while joining two columns.
Example
1) Number(38) = Number(4)
2) Varchar2(38) = Number(4)
[/CODE]
|
|
|
|
| Re: Data Type Mismatch [message #183898 is a reply to message #183890] |
Mon, 24 July 2006 05:13  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
There is no datatype mismatch in 1)
In 2), one of the columns (at the optimisers discretion) will be converted to the type of the other. I think it favours conversions to varchar2, but I can't remember where I read that.
This may well lead to lots of problems, which is why you should ALWAYS try to do the conversions explicitly - that way you get to control what happens.
|
|
|
|
|
|
| Re: Data Type Mismatch [message #183917 is a reply to message #183905] |
Mon, 24 July 2006 06:44 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
|
Or they could put in something like '100,347.23', which IS a valid number , but only if you use the right format mask.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
