| String parsing [message #247599] |
Tue, 26 June 2007 08:30  |
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  |
Bill B
Messages: 1971
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
