how can create the lexical parameter after the select class?

Answer Posted / ashutosh

just create a parameter
and write sql command in report like this...

select * from emp
where &condition

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the different types of columns in oracle reports.

572


from where do u receive the information to develop report

1531


Is it possible to execute a dynamic sql from forms?

599


what are the new features introduced in oracle form services in 11g release 2?

582


all steps of bitmap report?

1908






How to create Drill down report?

1696


What is an SQL FORMS ?

2312


List out the oracle forms configuration files?

567


What do you understand by oracle forms and why are they required?

557


Explain master-detail relationship with some examples.

588


Explain how one can iterate through items and records in a specified block?

546


Name the different triggers supported by oracle reports and their firing order.

591


what are the oracle forms services components include?

561


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2282


Why oracle forms required?

568