Re: Can SQL*Loader insert linefeeds?

From: <jmj22026_at_glaxowellcome.com>
Date: 1997/02/13
Message-ID: <33035645.804_at_glaxowellcome.com>#1/1

I was able to do this by first replacing all linefeeds with a special character. Just use an editor and replace with a special character you know will not be in the data. Use SQL*Load to get the data in. Then once the data is loaded write a PL*SQL program that uses the replace() function to put the line feeds back in.

John Jones
Oracle Consultant
jmj22026_at_glaxowellcome.com Received on Thu Feb 13 1997 - 00:00:00 CET

This message: [ Message body ]
Next message: Glen Wigg: "Re: Ease of Use/Learning Oracle development tools"
Previous message: davwoods_at_ucdavis.edu: "Re: MSAccess to update Oracle database ???"
In reply to: Dirk Schmatz: "Can SQL*Loader insert linefeeds?"
Next in thread: Glen Wigg: "Re: Ease of Use/Learning Oracle development tools"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message