rwdbCast()
The predefined expression, rwdbCast(), allows an application to change the type of a value in the database to another type. For example, with rwdbCast() you can change a number to a character string. The parameters for rwdbCast() should be specified in the following ways:
Casting to a character string: rwdbCast(expression,"CHAR")Casting to a number: rwdbCast(expression,"NUMBER")Casting to a date: rwdbCast(expression,"DATE")The above calls will produce Oracle conversion functions TO_CHAR, TO_NUMBER and TO_DATE respectively. As shown in Table 4, there are also three-parameter and four-parameter versions of the rwdbCast() expression. These can also be used to provide optional format and language parameters for the conversion functions.
