in SQL Loader, Can Caret (^) be used as delimiter?

Asked Mar 10 '14 at 04:16

Active Mar 10 '14 at 04:16

Viewed 272 times

I am using Oracle SQL Loader to load some data into database from a plain text file. Due to lots of special characters are contained in the data so we have to use caret ^ as the delimiter.

Just wondering whether SQL loader allows that to happen?

Thanks heaps in advance

asked Mar 10 '14 at 04:16

Jack Gao

Yes, you can use `^` (Carert) as a delimiter. There is no restriction against using ^ – Incognito Mar 10 '14 at 08:35
Hi Incognito, Thanks a lot for your help – Jack Gao Apr 03 '14 at 04:44

in SQL Loader, Can Caret (^) be used as delimiter?

0 Answers0