OraFAQ Forum: Reports & Discoverer » Most Most Most urgent, need ans with in while.. about temp table and matrix rep

Home » Developer & Programmer » Reports & Discoverer » Most Most Most urgent, need ans with in while.. about temp table and matrix rep

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Most Most Most urgent, need ans with in while.. about temp table and matrix rep [message #88878]

Tue, 27 May 2003 17:22

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

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Cross
Next Topic:	Urgently Required Help for communication error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 21:02:21 CST 2024