I have this query with a condition in Access and would like to know
how I can put a condition part in Oracle 9i SQL similiar to how Access
does it?


Current Access SQL that I want to rewrite in Oracle where I just need
to know how to do the condtion part: IIF( ISNULL(d.NOTES)=True,'Not
Available',d.NOTES) AS NOTES


SELECT
b.FirstName,
b.LastName,
c.FirstName,
c.LastName,
a.Info,
IIF( ISNULL(d.NOTES)=True,'Not Available',d.NOTES) AS NOTES
FROM
Person AS b,
Person AS c,
Notes AS d,
Main AS a
WHERE
a.MID= 34
And
b.PID=a.PO
And
c.PID=a.TE
And
d.MID=a.MID

francan00 (AT) yahoo (DOT) com wrote in news:b133ed52-4246-4363-92f0-62472dd44353
@d27g2000prf.googlegroups.com:

http://www.orafaq.com/forum/t/93239/74940/

francan00 (AT) yahoo (DOT) com wrote:
Look at the NVL and NVL2 functions.

www.psoug.org
click on Morgan's Library
click on Built-in functions near the top of the page.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Tue, 27 Nov 2007 19:35:41 -0800 (PST), francan00 (AT) yahoo (DOT) com wrote:


nvl(d.notes, 'Not available')

You can find all functions in the SQL reference manual.

--
Sybrand Bakker
Senior Oracle DBA