| |
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. |
| October 10, 2008 08:13:33 |
#2 |
| jitendra_kumar |
Member Since: October 2008 Total Comments: 2 |
RE: lexical references
|
| Lexical references is used to runtime dynamic where conditions. If you create query through query builder colon(:) must be used and this is used in after parameter form.
Jitendra kumar(software Engineer).
|
| |
Back To Question | |
