My Oracle Support Banner

How To Import Data That Contains New-line Characters using SQL Developer. (Doc ID 1528653.1)

Last updated on JANUARY 31, 2023

Applies to:

Oracle SQL Developer - Version 2.1.1 and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.