Re: [Q]: create table with select statement
From: Tony Scott <asc_at_cix.compulink.co.uk>
Date: Wed, 23 Mar 1994 23:00:06 GMT
Message-ID: <Cn53w7.CCF_at_cix.compulink.co.uk>
Date: Wed, 23 Mar 1994 23:00:06 GMT
Message-ID: <Cn53w7.CCF_at_cix.compulink.co.uk>
You can do it in PL/SQL. You make a cursor on the source table, FETCH the records one by one and INSERT them one by one into the new table. This will handle LONG columns.
Tony Scott
(asc_at_cix.compulink.co.uk)
Received on Thu Mar 24 1994 - 00:00:06 CET