Home » Developer & Programmer » Reports & Discoverer » Most Most Most urgent, need ans with in while.. about temp table and matrix rep
Most Most Most urgent, need ans with in while.. about temp table and matrix rep [message #88878] Tue, 27 May 2003 17:22 Go to next message
Muhammad Aurangzaib
Messages: 43
Registered: April 2003
Member
Heloooo

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
Re: Most Most Most urgent, need ans with in while.. about temp table and matrix rep [message #88879 is a reply to message #88878] Wed, 28 May 2003 00:09 Go to previous messageGo to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi,

You can table ROW as DNAME, but can't take column as JOB and matrix cell as JOB.

Create one more column as JOBID and select COLUMN as JOBID and matrix cell as JOB.

You will get the matrix report.

I don't know U R exactly looking for this type.

Try and C.

Muzzammil.
Re: Most Most Most urgent, need ans with in while.. about temp table and matrix rep [message #88884 is a reply to message #88879] Wed, 28 May 2003 22:54 Go to previous message
Muhammad Aurangzaib
Messages: 43
Registered: April 2003
Member
salam

thx a alot of yu answer....but problem i still therer ... that is temporary table... actually temporary table contains data only only for current session.... and oracle session is diffrent then report session.... so as we change the session data disappear... i mean not seem in report session... i want it soluation.... that it also seem in report session... if u can as please inform me... In my knowledge it is not possible... but may be my knowledge is low and u may give me best soluation....

thx
Previous Topic: Cross
Next Topic: Urgently Required Help for communication error
Goto Forum:
  


Current Time: Fri Mar 29 11:01:12 CDT 2024