Re: How do I use a field delimiter of more than 1 char in the data file?

On Wed, 09 Jul 1997 01:11:39 GMT, ben_at_paladin.ab.ca (Ben) wrote: Why do you want to have three delimiters and why will that make it foolproof? Why would a user be determining what and how many characters are the delimiter.

I can probably help you with what you're trying to do if I understand it a little more.

Thanks

Greg Teets
Cincinnati, Ohio
>
>Hello, I'm trying to load a data file using sqlload and I get this
>message:
>
>SQL*Loader-350: Syntax error at line 9.
>Expecting single char, found ":::".
>FIELDS TERMINATED BY ":::" OPTIONALLY ENCLOSED BY '"'
>
>I need to keep my delimiters 3 characters to make the user-entered
>data fool-proof (most of my users don't follow "don't do this"
>instructions too well), so how should I edit my control file to allow
>for 3 char delimiters? Any help appreciated! (I don't have access to
>my Oracle books)
>
>- Ben
>ben_at_paladin.ab.ca
>
>ps: also, 1) how do you (reverse-engineer) generate a delimited data
>file from and oracle table? 2) what is the regular way to do backups
>of an Oracle database? The only obvious files I see are the original
>data files.
Received on Wed Jul 09 1997 - 00:00:00 CDT