| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
