I don't think so. IIRC, when I looked at the same kind of stuff in SQL Server, there was a CASE statement. In this case, I think you have to write your own DECODE statement using the constants your can determine.
>For the datatype, the col$ view has a type# column. I can see that the following codes map to the corresponding data types:
>Type# Data Type
>----- ---------
> 2 Number
> 1 Varchar2
> 96 Char
> 12 Date
>Is there another system table that I can join to to get the actual names of the data types? TIA!
>
>>I hate retyping < arrgghh >! I tested it on one machine and posted using another.
>>
>>Glad it helped!
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao