Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to create Drill down report?

2072


Explain master-detail relationship with some examples.

948


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1089


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2250


In what sequence do triggers get fired by oracle forms?

912


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1171


what is the difference between call_form, new_form and open_form?

1214


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

981


What is an oracle report?

986


List the different types of columns in oracle reports.

937


a text item is there what r the different types of triggers associated with it

1939


how to send file attachment from oracle forms

2489


Name the different triggers associated with oracle forms having a master-detail relationship.

920


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2065


why the Ctl file u put only in bin folder why not in other folder

1993