How to know datatype? [message #38455] |
Thu, 18 April 2002 10:51 |
Arnab Dey
Messages: 6 Registered: April 2002
|
Junior Member |
|
|
Say I have a piece of data - how to know its datatype? - is there any standard function with Oracle/SQL that can do it for me?
eg - if the data is 12345 - then I need the answer as NUMBER, if the data is 'Oracle' - then answer should be VARCHAR or CHAR - in case data is like '17-APR-2002' answer would be DATE
Thanks
Arnab
|
|
|
Re: How to know datatype? [message #38463 is a reply to message #38455] |
Thu, 18 April 2002 18:05 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
You should use describer the object first (table or view) to check the datatype .. e.g desc objectname .. but i don't think that you can use some function to check the data type based on data. Hope this is helping
|
|
|