Re: Re-organizing tables containing LONG datatypes?
From: Steven Godkin <sgodkin_at_Sophia.NCR.COM>
Date: 5 Dec 94 12:19:47 GMT
Message-ID: <6025_at_ncrsoph.Sophia.NCR.COM>
Date: 5 Dec 94 12:19:47 GMT
Message-ID: <6025_at_ncrsoph.Sophia.NCR.COM>
I have used the COPY command and PL/SQL to deal with tables containing LONG fields. I beleive the COPY command requires a fully installed/setup SQLNet implementation, whereas some programming in PL/SQL could be generic Oracle code. In PL/SQL you need to create the table first, then you could use a CURSOR and INSERT commands to populate it.
Steven Godkin Received on Mon Dec 05 1994 - 13:19:47 CET