OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » SRW (oracle 10g reports)

Wed, 22 May 2013 14:38

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Hi,
I have one doubt.

EMPNO  ENAME  SAL  JOB        DEPTNO
7369   SMITH  800  CLERK        20
7521   WARD   1200 SALESMAN     30

Instead of data in column deptno I want to display like this

EMPNO  ENAME  SAL  JOB        DEPTNO
7369   SMITH  800  CLERK       RESEARCH
7521   WARD   1200 SALESMAN    SALES

There is any possibility using SRW package in reports to convert into above format.

thanks in advance.

[Updated on: Wed, 22 May 2013 14:40]

Wed, 22 May 2013 15:38

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SRW package? No idea, but an ordinary JOIN is perfectly capable of doing that job.

Previous Topic:	pdf tags in Oracle reports
Next Topic:	Masking number to word

Goto Forum:

]

Current Time: Thu Jan 30 17:35:17 CST 2025