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;

What are all difference between business objects 6.5 and xi r2?

1015

---

What is the difference between user and versatile user?

1054

---

what is xcelsius architecture?

4567

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

1022

---

How many universes can be created in a project?

1021

---

Can you please send me the migration related issues .

2066

---

What is aggregate table and aggregate fact table ... Any examples of both?

1049

---

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2430

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10364

---

Explain is there any default username & pwd for bo designer & supervisor?

988

---

Differences between business objects and web intelligence reports?

1195

---

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6843

---

What task is 98% of the required work of a business analyst?

1029

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1859

---

What is object stores?

967

---