Re: LONG want to convert to VARCHAR

From: Chris Jack <chrisj_at_pro-data.demon.co.uk>
Date: Thu, 8 Jul 1993 10:55:00 +0000
Message-ID: <742128900snz_at_pro-data.demon.co.uk>


In article <1993Jul7.144052.1152_at_macc.wisc.edu> dly_at_vms.macc.wisc.edu writes:

>We are using ORACLE 7.0.12 on Sun/Unix 4.1.3
>
>I made the mistake of creating a table with type LONG. How can I get
>the information out into a file? I've tried sqlplus with the set long 500
>command, with wrap on. For one specific record, it will print out the
>value, but when I want to do the entire table, I get only the first 80
>chars or so.

Can you write a program that selects all the rows and columns into appropriate data types in a C program and simply INSERT them into the new table?

-- 
Chris Jack
Received on Thu Jul 08 1993 - 12:55:00 CEST

Original text of this message