OraFAQ Forum: Reports & Discoverer » Column name as parameter

Home » Developer & Programmer » Reports & Discoverer » Column name as parameter (Oracle10G, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Column name as parameter [message #410498]

Sat, 27 June 2009 11:42

sudd13
Messages: 5
Registered: June 2009

Junior Member

select * from emp where hdate between 01/01/09 and 01/02/09;

I need to pass the column name as parameter as well as the values like----

select * from emp where &hdate between :f_dt and :l_dt;

Here in form report builder 10G &hdate are not accepted as column name. But where as colon it's accepted at report builder like--------

select * from emp where :hdate between :f_dt and :l_dt;

but not showing any data. Can anyone help me????

Report message to a moderator

Re: Column name as parameter [message #410501 is a reply to message #410498]

Sat, 27 June 2009 12:52

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Try this as the query.

select * from emp
&where_clause ;

In Before Report trigger:

where_clause := 'where ' || :hdate || ' between ''' || :f_dt 
                || ''' and ''' || :l_dt || ''';

By
Vamsi

Report message to a moderator

Previous Topic:	literal does not match format string
Next Topic:	How to disable Reports 6i Previewer (merged 4) windows xp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 22:00:57 CDT 2024