[sqr-users] Dyanmic variable in select query.

["Shailesh Sugandhi" <shailesh.sugandhi@patni.com>]

Hi,

My requirement is, I have to add one dynamic variable to existing SQR select
clause. Depending on condition, its value needs to be populated. E.g My
exisitng query is :

select
A from TableA1.

if {Condition}
$Dynamic_var = 'Some Table name'
else
{Dynamic variable should be empty}

What i should write if i don't want to pass any table name in case if
condition is false. Can i safely write 'dual'?

For example,

if {condition is false}
select
A from TableA1, dual.


Thanks & Regards,
Shailesh Sugandhi

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users