Re: To make a copy of a table

From: Mabel <mabelle_at_bluewin.ch>
Date: 1998/01/10
Message-ID: <01bd1e32$82aa7850$570bbac3@m3bj1>#1/1

I do not understand why you need to do this, but anyway create a PL/SQL with a cursor

CURSOR source_table IS
  SELECT * FROM t1
  ORDER BY colx;
BEGIN
   FOR i IN source_table LOOP

      INSERT INTO t2
      (c1, c2, c3, bla, bla);

   END LOOP;
END; Jean-Luc Demoisson <cicg_at_cicg-communication.grenet.fr> wrote in article <693393$5i6$1_at_naiad.grenet.fr>...
> I want to make a copy of a table in alphabetical order.
> I tried to do this:
> create table T2 as select * from T1 order by colX;
> This does not work...
> Thanks for replies
>
> Jean_Luc demoisson
> jld_at_grenet.fr
>
>
>
Received on Sat Jan 10 1998 - 00:00:00 CST