Using internal variable in Report Builder using SQL, but not making it a User Parameter
Hello All,
I have a plane SQL code for generating report using Oracle Report Builder tool, as mentioned below:
Select t1.a, t2.b,t1.c, t1.d from t1, t2
where t2.e in (Select t4.g from t4 where t4.f in (Select t6.k from t6
where t6.m = 'expression'
and condition6
and condition7
)
and condition3
and condition4
)
and condition1
and condition2
Union all
Select t1.a, t2.b,t1.c, t1.d from t1, t2
where t2.e in (Select t4.g from t4 where t4.f in (Select t6.k from t6
where t6.m =