OraFAQ Forum: Reports & Discoverer » If empno is null then show all record

Home » Developer & Programmer » Reports & Discoverer » If empno is null then show all record (10g,Developer 6I,Window XP)

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

If empno is null then show all record [message #383115]

Tue, 27 January 2009 05:24

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Hellow

I have a question that i make a report which contain all emp record like

Select * from emp where empno=:Empno

now i want

when empno will null its show me all record of emp table

Hope all of you understand

Thanks

Shahzaib ismail

Report message to a moderator

Re: If empno is null then show all record [message #383123 is a reply to message #383115]

Tue, 27 January 2009 05:55

vivekbhatt23
Messages: 5
Registered: January 2009
Location: delhi

Junior Member

u can try
select * from emp where empno=:Empno or :Empno is null

it will work.

Report message to a moderator

Re: If empno is null then show all record [message #383124 is a reply to message #383115]

Tue, 27 January 2009 05:57

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

Senior Member
Account Moderator

select * from emp e
where e.empno = nvl(:empno, e.empno)

Report message to a moderator

Previous Topic:	HELP: Discoverer Error
Next Topic:	REP-1212 error message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:01:32 CDT 2024