Home » Developer & Programmer » Reports & Discoverer » Same column but more than one values (Reports 6i)
Same column but more than one values [message #295755] Wed, 23 January 2008 05:25 Go to next message
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

Re: Same column but more than one values [message #295756 is a reply to message #295755] Wed, 23 January 2008 05:41 Go to previous message
Littlefoot
Messages: 20901
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
Previous Topic: REP - 0801: (Report Builder Error)
Next Topic: how to call a report from sql
Goto Forum:
  


Current Time: Sat Dec 10 18:42:25 CST 2016

Total time taken to generate the page: 0.10370 seconds