I hope that I am missing something obvious -- if someone could point me in the right direction, I would be very appreciative.
I have XML data that I am trying to convert into SQL DML for Oracle (my XML to DDL works fine). My XML data includes Timestamps (and/or Dates), and I believe that in order to insert this into Oracle, I am going to have to call the Oracle functions "to_timestamp" (or "to_date"). (If I am mistaken, please let me know.)
My data looks like (summarized),
My schema looks like (summarized),
(Note the timestamps.)
And unfortunately, my SQL results in:
insert into pubtitle values( '1', 'Guide to Backpacking', '32.12', '1/2/1998' );
But I think it needs to be something like this (either using to_date, or to_timestamp):
insert into pubtitle values( '1', 'Guide to Backpacking', '32.12', TO_DATE('1/2/1998', 'MM/DD/YYYY'));
Are there Ant tasks or properties (or even Java API) that can be used to create SQL suitable for insertion into Oracle, including dates / timestamps? Note that I just want the SQL, I can't use Java to read/populate the database directly.
Thanks in advance,
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.