Re: Can SQL*Loader insert linefeeds?

From: <jmj22026_at_glaxowellcome.com>
Date: 1997/02/13
Message-ID: <33035645.804@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 CST

This message: [ Message body ]
Next message: Cliff Sockman: "Web Server Auth (using DB)"
Previous message: Ron: "Re: Can SQL*Loader insert linefeeds?"
In reply to: Dirk Schmatz: "Can SQL*Loader insert linefeeds?"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US