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: 1629
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: Fri Jun 23 01:55:01 CDT 2017

Total time taken to generate the page: 0.15497 seconds