Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Definitions
Message
 
 
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00841091
Message ID:
00841316
Vues:
28
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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform