OraFAQ Forum: Reports & Discoverer » How to create a whereclause at runtime

Home » Developer & Programmer » Reports & Discoverer » How to create a whereclause at runtime (report builder 6i)

Wed, 02 September 2009 15:16

deahayes3
Messages: 203
Registered: May 2006

Senior Member

Hello all,

Is there a way I can add to a Where Clause in report builder at runtime.

for example,

select * from table where :p1;

Wed, 02 September 2009 23:52

shaz
Messages: 182
Registered: June 2009

Senior Member

It can be done using lexical parameter.

Read about it.

Previous Topic:	issue while skipping even pages
Next Topic:	Orace Reports 10 Formating on web problem in matrix report

Goto Forum:

]

Current Time: Thu Nov 20 15:46:59 CST 2025