Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!apple!olivea!mintaka!bloom-beacon!eru!hagbard!sunic!uts!idathon
From: idathon@uts.uni-c.dk (Hans O. Nymand)
Newsgroups: comp.databases
Subject: Variables in ORACLE
Summary: How do i get the value from a DECLARED variable into a DEFINED variable
Keywords: variables,oracle,define,declare,select into,substitution
Message-ID: <1991May3.112910.28366@uts.uni-c.dk>
Date: 3 May 91 11:29:10 GMT
Distribution: all
Organization: UNI-C, Danish Computing Centre for Research and Education
Lines: 17

Hi

My problem (i think) is to give the value from a DECLARED variable to a DEFINED
variable.

What i really want is to find the name of a table in another table, i.e.

     SELECT tabname INTO thefoundtable FROM tableoftables

and then be able to select from this found table

     SELECT * FROM thefoundtable




Hans Olav