By Administrator on 2010-01-24 16:57:32
Category - Data Loading
SQL Loader - how to specify specific record delimiter (separator) character
If you data file to be loaded has some non-common character as record delimiter, then you can use "STR" clause in your INFILE of sqlldr control file. See this for an example on this - 

SQL Loader (sqlldr) - fields delimited by chr(1) or (^A) and records delimited by chr(2) or (^B) 




Please login first to post a comment on this thread OR to create a new thread...
Google best Oracle sites right from here >