[comp.databases] ALTER TABLE in ORACLE/V6

idathon@uts.uni-c.dk (Hans O. Nymand) (05/17/91)

Hi

My problem is that i want to generate a table with field-names, which is
rows in another table, i.e. the parent-table contains the rows

       FNAME1 ...
       FNAME2 ...

and i want to construct a table like

   CREATE TABLE ... ( Fname1 NUMBER, Fname2 NUMBER, ... );

I have tried to call ALTER TABLE from within a CURSOR-LOOP and use
the CHARTOROWID conversion, but i get the error message

Found "ALTER"



What should I do?

Hans Olav