Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


HI
in report builder am creating paramters.for that i have
taken emp table from scott user .

in deptnum am displaying distinct deptno.if i select dept
10 ,empnum drop down should display empno's of deptno 10.
.if i select dept 20 ,empnum drop down should display
empno's of deptno 20.for this wat i have to do.

Answers were Sorted based on User's Feedback



HI in report builder am creating paramters.for that i have taken emp table from scott user . ..

Answer / raghav

first create a sql query in the data model like below
select empno from emp no where deptno=:p_deptno.run the
report

Is This Answer Correct ?    0 Yes 0 No

HI in report builder am creating paramters.for that i have taken emp table from scott user . ..

Answer / praveen

sorry raghav it won't work i want dependent dropdown not
report output

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

What is the use of Printer Definition file (PRT) in Reports ?

1 Answers   Epson, GE,


What are built-ins associated with timers?

2 Answers  


what is integrity n how many integrity rules r there?

2 Answers   Convergys,


Can a formula column refered to columns in higher group?

1 Answers  


Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

0 Answers   GE,






What is difference between open_form and call_form?

2 Answers  


How can you format a character field in a report Layout editor ?

1 Answers   Convergys,


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

0 Answers  


I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad

2 Answers  


What is the use of break group?

1 Answers  


i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

0 Answers  


List out the oracle forms configuration files?

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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 (509)
  • 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)