I agree that the first method will work in SQL*Plus, but the second
method won't. Trying to use a variable in place of a table name in an
embedded SQL statement will generate a compiler error. You must use
dynamic SQL. What environment are you using: SQL*Plus, Pro-C, OCI??
TurkBear wrote:
>
> How are you planning to execute the select statement...
>
> If from SqlPLus than you can write a script the has:
>
> Select * from &tablename
>
> It will prompt you for a table name when run...
>
> with other methods, assign the tablename to a string variable ( varchar2 for
> example and use it like
> select * from :tablename variable
>
> "Starman" <ninomail_at_tin.it> wrote:
>
> >Hi all,
> >
> >I need to execute a SELECT statement but I want the "FROM table" variable.
> >
> >for ex. : SELECT * FROM <tablename>;
> >
> >where tablename is a variable.
> >
> >Is it possible? If not, is there another way?
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
Received on Mon Oct 25 1999 - 10:31:40 CDT
