Home » SQL & PL/SQL » SQL & PL/SQL » String parsing
String parsing [message #247599] Tue, 26 June 2007 08:30 Go to next message
Messages: 79
Registered: March 2007
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

Re: String parsing [message #247606 is a reply to message #247599] Tue, 26 June 2007 08:35 Go to previous message
Bill B
Messages: 1662
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: How To recall old data
Next Topic: Writing Excel Document from PL/SQL
Goto Forum:

Current Time: Sat Aug 19 23:01:01 CDT 2017

Total time taken to generate the page: 0.46100 seconds