can u call procedure or function is sq l query in reports
Answer Posted / swarna
We can call the Function in the sql query in reports but
not the Procedure.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What do you understand by oracle forms and why are they required?
what is a package n what r the packages availbla in report
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
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
Name the different triggers supported by oracle reports and their firing order.
what exactly u write in when_new_form_instance
what is difference between group above and group left report
if u want to delete all these detail block etc what will happen in form
What do you understand by lov?
what are the oracle forms services components include?
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
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
what are bind variables?
List the different types of columns in oracle reports.