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>
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 JackReceived on Thu Jul 08 1993 - 12:55:00 CEST