Home » SQL & PL/SQL » SQL & PL/SQL » How to query of the table has a CHAR data type
How to query of the table has a CHAR data type [message #337731] Thu, 31 July 2008 21:28 Go to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Hi,

I have a table that some integer value only and some is CHAR in a particular column. Is there a view or packages in ORACLE that can help me find if the records is only interger or CHAR only?

Hope you can help me. thanks.
Re: How to query of the table has a CHAR data type [message #337732 is a reply to message #337731] Thu, 31 July 2008 21:56 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above


Re: How to query of the table has a CHAR data type [message #337755 is a reply to message #337731] Fri, 01 August 2008 00:59 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is no built-in but if you searched a little bit you'll find many ways to do it.
I answered this question for the first time 10 years ago and I'm pretty sure I was not the first one, since many has also be posted and answered including here.

Regards
Michel
Previous Topic: Regarding columns of number and string datatype comparisons
Next Topic: Hows Oracle Lock Works
Goto Forum:
  


Current Time: Sun Dec 04 16:26:33 CST 2016

Total time taken to generate the page: 0.10232 seconds