How To Import Data That Contains New-line Characters using SQL Developer.
Last updated on MARCH 21, 2018
Applies to:Oracle SQL Developer - Version 2.1.1 and later
Information in this document applies to any platform.
You have data in excel sheet and would like to import to oracle tables using SQL Developer's import options.
Data which is in excel sheet contains wrapped lines, newline characters. While importing such data you see that insert statement script formed contains truncated data or constructed script has stmt. which fails.
This Documents provides options to ensure while importing such data.
Sample data as how it appears at SQL Developer is show here.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms