Hi frnds,
I want to get column name dynamically from prompt in tabular SQL. Is it possible?
select distinct /*+ FIRST_ROWS */ e.empdate from emp e where #prompt('cond')# between to_date(#prompt('stdate')#,'DD-MM-YYYY') AND to_date('29-OCT-2005','DD-MM-YYYY')
In place of #prompt('cond')# i will give the column name.Its working fine in oracle but not working in tabular SQL. Try to help me. Thanks in advance
Mrcool