Interested to Buy Any Domain ? << Click Here >> for more details...
Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
- 4 Answers
- 11988 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / deepak
hi chandu,
this is a sample one
create or replace procedure proc_name(proc_cur in out
sys_refcursor)
as
begin
open proc_cur for select * from tab;
end;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain what is aggregate table and aggregate fact table ... Any examples of both?
explain in detail about type 3?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain about a task that really tested your analytical abilities?
What Is The Difference Between Oltp And Olap?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What Is Snow Flake Schema?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what is the difference b/w the refresh and buffered data?
Explain which versions are used in the bo dashboard work?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain in detail about type 2(scd),
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
