How does sql*loader handles newline characters in a record? : aql loader
- 1 Answers
- 1117 Views
- I also Faced
- E-Mail Answers
Answer Posted / Dinesh Kumar Bhaskar
SQL*Loader treats newline characters as field terminators by default. If you have records with multiple lines, they will be treated as separate records. To change this behavior, you can use the FIELDS TERMINATED BY option in your control file to specify another character as a field separator.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is your daily office routine?
Is primary key clustered index?
what are aggregate and scalar functions? : Sql dba
define sql insert statement ? : Sql dba
Can delete statement be rollbacked?
what are all the common sql function? : Sql dba
Can we use distinct and group by together?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how many tables will create when we create table, what are they? : Sql dba
How do I remove duplicates in two columns?
what are the advantages of sql ? : Sql dba
what is schema? : Sql dba
What is the best sql course?
how to escape special characters in sql statements? : Sql dba
Is primary key always clustered index?
