I am using the cloud version of APEX for a college course. The database script I am trying to load has dates formatted in "DD-MON-RR" and I receive 'not a valid month' and 'a non-numeric character was found where a numeric was expected'. Is there a workaround in APEX for this? I'm trying to avoid changing thousands of lines of data.
Any hint on what the script looks like?
If it's just a bunch of inserts, you probably have two options
1) Add the "alter session" at the top, as described
2) Use text editor to perform bulk update first