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...


in reports 1og.if we enter a query in list of values then
parameter form displays a dropdown.in that if any ething is
selected then that will display in the report.supp if i am
not selected any value then it should display all the
values.how it is possible?can any one help me........



in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in th..

Answer / tech knit

first in the main query add to parameter...
supp :deptnum is parameter
then
query...............where :deptnum or :deptnum is null

and in parameter lovs write query
after writing the query in lovs ..uncheck the check box --
'the restrict list to predetermined values'

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

When to use Place holder columns in Oracle Reports and what is a place holder column?

2 Answers  


Two popup pages can appear on the screen at a time ?

1 Answers  


difference between place holder and formula column

3 Answers   Cognizant, IBM, Microsoft,


what is procedure like symbols of bind and lexical

1 Answers  


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

0 Answers  


What is forms_DDL?

2 Answers  


How can you create Lexical parameter n Bind parameter in Reports ?

1 Answers   GE, SVSS,


How do you pass the parameters from one form to another form?

2 Answers  


Is it possible to split the printpreviewer into more than one region?

1 Answers  


.fmb will be in which folder

2 Answers  


how do u call a report from form

3 Answers   Wipro,


What are the different window events activated at runtimes?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)