Re: What does columnname::datatype do in a where clause
Your where clause would be translated into:
WHERE Reseler_Profile.Status_ID = Reseller_Status.Status_ID AND
(param_Reseller_Id IS NULL or CAST(Reseler_Profile.Reseller_Id AS CHAR(4)) LIKE param_Reseller_Id)
The ::CHAR(4) was replaced with CAST( xxx AS CHAR(4))
However, I recommend to avoid a CAST in a situation where you'll be increasing the field size, or where performance is an absolute must. It would be better to reduce the 'other' field's size rather than increase a size.
Subject
Views
Written By
Posted
8743
July 26, 2005 02:49PM
Re: What does columnname::datatype do in a where clause
6342
August 02, 2005 09:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.