I have the following SQL:
Select field1, field2, field3, additional_info
where to_date(substr(additional_info,4,10), 'yyyy/mm/dd') > '01-apr-2013'
I receive the message "ORA-01841: (full) year must be between -4713 and +9999"
The field "additional_info is a varchar date type and all records start with 'AB:2012/03/13 '.............
Can anyone help me?
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…