How To Import Data That Contains New-line Characters using SQL Developer.

(Doc ID 1528653.1)

Last updated on NOVEMBER 22, 2013

Applies to:

Oracle SQL Developer - Version 2.1.1 and later
Information in this document applies to any platform.

Goal

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.

 

 

Solution

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