Home » Developer & Programmer » Reports & Discoverer » how i make a matrix reports on temporary table with columns of dname,job
how i make a matrix reports on temporary table with columns of dname,job [message #88877] Tue, 27 May 2003 17:18
Muhammad Aurangzaib
Messages: 43
Registered: April 2003
Member
salam

I have a problem, wants to get urgent ans.

i make a temporary table as and make a procedures with seqance of

1 create global temporary table temp_table (
2 dname varchar2(30),
3 job varchar2(30))
4* on commit preserve rows
SQL> /

Table created.

SQL> create or replace procedure temp_proc as
2 cursor c1 is select dname,job from emp e,dept d
3 where d.deptno = e.deptno;
4 begin
5 for rec in c1 loop
6 insert into temp_table values(rec.dname,rec.job);
7 end loop;
8 end;
9 /

Procedure created.

SQL> select * from temp_table;

no rows selected

SQL> execute temp_proc;

PL/SQL procedure successfully completed.

SQL> /

DNAME JOB
------------------------------ ------------------------------
RESEARCH CLERK
SALES SALESMAN
SALES SALESMAN
RESEARCH MANAGER
SALES SALESMAN
SALES MANAGER
ACCOUNTING MANAGER
RESEARCH ANALYST
ACCOUNTING PRESIDENT
SALES SALESMAN
RESEARCH CLERK

DNAME JOB
------------------------------ ------------------------------
SALES CLERK
RESEARCH ANALYST
ACCOUNTING CLERK

14 rows selected.

SQL> commit;

Commit complete.

Now i wants a matrix report with side rows are dname and matrix cell will be job...

but problem is temporary table... as I leave a session data disappear....

what i do.... please I need very very very urgent solation... with in few mins...
thx a lots
Previous Topic: Report output in a spool file
Next Topic: DATA IN SECOND PAGE COMES FROM MIDDLE OF PAGE
Goto Forum:
  


Current Time: Fri May 24 21:31:18 CDT 2024