OraFAQ Forum: Reports & Discoverer » Same column but more than one values

Home » Developer & Programmer » Reports & Discoverer » Same column but more than one values (Reports 6i)

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

Same column but more than one values [message #295755]

Wed, 23 January 2008 05:25

gozuhair
Messages: 206
Registered: January 2008

Senior Member

Dear All

Can anyone tell me how can i give multiple input parameter of asame column with out using "In" operator

Ragards

Zuhair

Report message to a moderator

Re: Same column but more than one values [message #295756 is a reply to message #295755]

Wed, 23 January 2008 05:41

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

Senior Member
Account Moderator

This is what you already have: IN:

SQL> select dname from dept
  2  where deptno in (10, 20);

DNAME
--------------
ACCOUNTING
RESEARCH

Do the same using the OR operator:

SQL> select dname from dept
  2  where (deptno = 10
  3         or
  4         deptno = 20
  5        );

DNAME
--------------
ACCOUNTING
RESEARCH

SQL>

Or, you might even try with UNION (ALL):

SQL> select dname from dept where deptno = 10
  2  union all
  3  select dname from dept where deptno = 20;

DNAME
--------------
ACCOUNTING
RESEARCH

Report message to a moderator

Previous Topic:	REP - 0801: (Report Builder Error)
Next Topic:	how to call a report from sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 09:05:18 CDT 2024