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!