Home » SQL & PL/SQL » SQL & PL/SQL » How to judge a columne's datatype is number or not ?
How to judge a columne's datatype is number or not ? [message #40678] Wed, 30 October 2002 07:02 Go to next message
wyshuai
Messages: 13
Registered: December 2000
Junior Member
Is there something like Is_number ?
Thanks.

Report message to a moderator

Re: How to judge a columne's datatype is number or not ? [message #40680 is a reply to message #40678] Wed, 30 October 2002 08:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
pls refer to our other posting
http://orafaq.net/msgboard/plsql/messages/8858.htm

Report message to a moderator

Re: How to judge a columne's datatype is number or not ? [message #40726 is a reply to message #40678] Sun, 03 November 2002 07:41 Go to previous message
Sreenivas
Messages: 15
Registered: January 2000
Junior Member
Dear Wyshuai,
You can refer to all_tab_columns table for
getting the column datatype..

Regards,
Sreeni

Report message to a moderator

Previous Topic: Urgent Query
Next Topic: Help installing oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 15:56:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.