Home » SQL & PL/SQL » Client Tools » SQL Developer Data Wizard - Row terminator question
SQL Developer Data Wizard - Row terminator question [message #524639] Sun, 25 September 2011 21:27 Go to next message
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 Go to previous messageGo to next message
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 69 times)
Re: SQL Developer Data Wizard - Row terminator question [message #524943 is a reply to message #524753] Tue, 27 September 2011 14:39 Go to previous message
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.
Previous Topic: Advice on Best way to create this Report
Next Topic: third party tool to migrate Oracle to Mysql
Goto Forum:
  


Current Time: Thu Nov 27 04:04:11 CST 2014

Total time taken to generate the page: 0.12623 seconds