Re: Text Files into Oracle?

John N. Alegre wrote:
> I have a question on putting text files into Oracle 8i.
>
> These would be one page text files, interchangeable between DOS and UNIX
> <CR>. I want to put the file in and preserve formatting. Since these
> are ASCII text files formatting here means only spaces and <CR>
>
> What is the best data type to use?
> What is the best command to put the date in oracle? Note that I do not
> want to have to copy and paste the text. I want to put the text in
> directly from the file and dump it from oracle directly to a text file.
>
> All comments welcome
> john
> ------------------------------------o------
> John N. Alegre o
> Andante Systems o
> eCommerce Consulting o
> Custom Web Development <*{{{{}><
> -------------------------------------------
>

CLOB's - do not use raw/long raw (depreciated and NLS sensitive)

-- 
Regards, Frank van Bortel