OraFAQ Forum: Reports & Discoverer » how to use param's in reports

Home » Developer & Programmer » Reports & Discoverer » how to use param's in reports

Mon, 07 July 2014 00:22

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

how to use 2 parameters in the reports?Please suggest.

SELECT ename, 
       (SELECT Max(hiredate) 
        FROM   emp 
        WHERE  empno = p_empno)next_date 
FROM   emp 
WHERE  deptno =p_deptno--10

Thanks

		how to use param's in reports By: mist598 on Mon, 07 July 2014 00:22
		Re: how to use param's in reports By: azamkhan on Mon, 07 July 2014 00:38
		Re: how to use param's in reports By: Littlefoot on Mon, 07 July 2014 05:53

Previous Topic:	0 instead of null column based on 2-queries (CM merged 2)
Next Topic:	How to run sql query

Goto Forum:

]

Current Time: Thu Apr 25 19:14:07 CDT 2024