D2K - How will you pass whole query from Form builder to Report?

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 28 of 71

How will you pass whole query from Form builder to Report?

Total Answers and Comments: 4

Last Update: September 09, 2008 Asked by: nitin kumat

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 15, 2006 04:20:00

Shantaram D. Ingale

RE: How will you pass whole query from Form builder to...

u can use

get_block_property('blk_name' last_query)

it will return the query executed last in varchar

use instr function to get query from 'where' clause to lexical parameter to report

u can use lexical parameter to listen the where clause from report

Is this answer useful? Yes | No

September 27, 2007 01:14:33

Mital Mehta

RE: How will you pass whole query from Form builder to...

Shantaram By this you can get Only the Last recent query from the Perticular block

But hte here thing is How to Pass Over there ? You can Pass through Parameter and use the lexical paramter and use into the report query

Is this answer useful? Yes | No

May 29, 2008 23:50:21

prasant0661

Member Since: May 2008 Contribution: 4

RE: How will you pass whole query from Form builder to Report?

You can put the query result in temprary table then use it in report

Is this answer useful? Yes | No

September 09, 2008 01:45:18

rajnish2008

Member Since: September 2008 Contribution: 1

RE: How will you pass whole query from Form builder to Report?

You can create a record group using your query in the form. Then you can pass record group as data_parameter to the report. This way query in the report will get replaced by the record group query passed from forms.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank