Home » Developer & Programmer » Forms » how to check if a number field is a number?
how to check if a number field is a number? [message #86897] Thu, 18 November 2004 12:24 Go to next message
sriram
Messages: 58
Registered: September 2000
Member
hey all,

how can you check if a parameter is a NUMBER or a CHAR in Oracle. I am reading flat files into staging tables(has only character fields) and then validate if it is a NUMBER and insert them into a seperate table(using a stored procedure). How can I do the validation part? Thanks any help is appretiated.

-sriram 

 

Report message to a moderator

Re: how to check if a number field is a number? [message #86915 is a reply to message #86897] Fri, 19 November 2004 18:41 Go to previous messageGo to next message
S. Sathish Kumar
Messages: 11
Registered: October 2004
Junior Member
You can use
get_item_property('item_name',datatype);

S. Sathish Kumar

Report message to a moderator

Re: how to check if a number field is a number? [message #86965 is a reply to message #86897] Wed, 24 November 2004 04:48 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
User To_number(column_name)...if it returns Error its not a numeric value as Simple as That..:-)

Cheers
Ram

Report message to a moderator

Previous Topic: query question
Next Topic: help needed for Array / Type using in Form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 07 15:55:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.