Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL HELP: Dynamic TABLE name from SQL query

PL/SQL HELP: Dynamic TABLE name from SQL query

From: Patrick Drouin <patrick.drouin_at_nortel.com>
Date: 1997/10/08
Message-ID: <343BD9B3.5304@nortel.com>#1/1

Hello everyone,

 Here's my problem : I want to be able to read a table's name from a table where I keep some information and then use this information in a SELECT statement. Can I get all of my SELECT statement build in a variable or in a field in a temp database and then execute the string? That sounds easy and I am sure that it can be done in Oracle but I just can't figure out how...

 Ciao, Patrick Received on Wed Oct 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US