Re: An Interesting Question ....

From: Heggelund <d92hegge_at_hfk.mil.no>
Date: 1997/09/09
Message-ID: <1997Sep9.080434.4543@ix_prod.hfk.mil.no>#1/1

Hi,

something like this should work:

select dept.deptno
, dept.deptname

from dept
where dept.deptno = :deptno
union all
select dept.deptno
, dept.deptname

from dept
where dept.deptno = '010'
and not exists (select null

                   from   dept d2
                   where  d2.deptno = :deptno
                  )

/

Rgds
Steinar Heggelund

---

I'm employed in the Norwegian consulting company Opus One AS. I have 7 years experience with Oracle products, mainly the database. We are a small company which offers consulting services in design, implementation and tuning of databases and applications based on Oracle.

My postings represent my opinions and they may be wrong. Received on Tue Sep 09 1997 - 00:00:00 CDT