I am making an oracle 10g report and in Query Builder I tried to use lexical reference after the from clauselike SELECT ORDID, TOTALFROM &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.

Rkhatri

 Profile Answers by Rkhatri Questions by Rkhatri

• Feb 25th, 2009

It is working fine with Oracle 10g and even with 11gSQL>select &a, &b from &tablename;It will ask respective values and it work fine

jitendra_kumar

 Profile Answers by jitendra_kumar Questions by jitendra_kumar

• Oct 31st, 2008

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).

Answer Question  Select Best Answer