OraFAQ Forum: Client Tools » SQL Developer Data Wizard

Home » Other » Client Tools » SQL Developer Data Wizard - Row terminator question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Developer Data Wizard - Row terminator question [message #524639]

Sun, 25 September 2011 21:27

akvaidyanathan
Messages: 3
Registered: September 2011
Location: Alexandria

Junior Member

Hi all,

I'm new to SQL Developer and am using the wizard to import a dataset with a non-standard row terminator

The row terminator is essentially 2 spaces back to back.

In SQL Server I specified the following in the SQL Server wizard and it worked:

{CR}{LF}{CR}{LF}

What's the equivalent for oracle?

Thanks for your help!

[Updated on: Sun, 25 September 2011 21:27]

Report message to a moderator

Re: SQL Developer Data Wizard - Row terminator question [message #524753 is a reply to message #524639]

Mon, 26 September 2011 09:20

akvaidyanathan
Messages: 3
Registered: September 2011
Location: Alexandria

Junior Member

I must clarify by saying that the row terminator is not exactly 2 spaces but 2 new line characters.

I have attached a sample.The column delimiter would be |

Just want to know what should I code the row terminator for this in the SQL Data Upload wizard

The default is this:

Windows <CR><LF>

Attachment: sample.txt
(Size: 0.26KB, Downloaded 2263 times)

Report message to a moderator

Re: SQL Developer Data Wizard - Row terminator question [message #524943 is a reply to message #524753]

Tue, 27 September 2011 14:39

akvaidyanathan
Messages: 3
Registered: September 2011
Location: Alexandria

Junior Member

Hi all,

wondering if anyone had some thoughts on this one?

or would like me to provide further information?

Thanks.

Report message to a moderator

Previous Topic:	Advice on Best way to create this Report
Next Topic:	third party tool to migrate Oracle to Mysql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 00:17:52 CST 2025