Home » SQL & PL/SQL » SQL & PL/SQL » String parsing
String parsing [message #247599] Tue, 26 June 2007 08:30 Go to next message
yog_23
Messages: 79
Registered: March 2007
Member
Is there any documentation on how to parse string values in oracle ?

Situation :
Having open fields that have sometimes high and low value dates (12/31/9999, 12/31/2200,01/01/1753) , dollars, sometimes a character string..Sometimes its null and sometimes it has spaces.

How do we validate these in oracle ?

Hope there are some library functions available ?

Thank you
Yog

Re: String parsing [message #247606 is a reply to message #247599] Tue, 26 June 2007 08:35 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
If the column can be anything, then how can you validate it. This sounds more like a database design issue and not a validation error. If you have 20 (for example) different types of information, you do not free format it into a varchar2 field, you make 20 columns or child tables.
Previous Topic: set values to timestamp .
Next Topic: Edit an Existing Stored Procedure/Trigger in Notepad
Goto Forum:
  


Current Time: Thu Dec 08 12:45:58 CST 2016

Total time taken to generate the page: 0.11079 seconds