Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!samsung!think.com!mintaka!bloom-beacon!eru!hagbard!sunic!uts!idathon
From: idathon@uts.uni-c.dk (Hans O. Nymand)
Newsgroups: comp.databases
Subject: ALTER TABLE in ORACLE/V6
Summary: How do I call the ALTER TABLE command from within a block?
Keywords: ALTER,BEGIN,BLOCK
Message-ID: <1991May17.120941.11893@uts.uni-c.dk>
Date: 17 May 91 12:09:41 GMT
Distribution: all
Organization: UNI-C, Danish Computing Centre for Research and Education
Lines: 22

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