| |
GeekInterview.com > Interview Questions > Oracle > D2K
| Print | |
Question: lexical references
Answer: I am making an oracle 10g report and in Query Builder I tried to use lexical reference after the from clause
like
SELECT ORDID, TOTAL
FROM &ATABLE;
But it was showing me an error "invalid table name"
Can't i use a lexical reference to make me enter the table name at run time?
please help. |
| February 02, 2009 02:42:40 |
#3 |
| Rkhatri |
Member Since: February 2009 Total Comments: 1 |
RE: lexical references
|
It is working fine with Oracle 10g and even with 11g
SQL>select &a, &b from &tablename;
It will ask respective values and it work fine
|
| |
Back To Question | |
