by wyk.. » Thu, 01 Jul 1999 04:00:00
Once again I need equivalent SQL behavior to an SQL Server query in
ORACLE.
The value in the select is the difference in dates unless the difference
returns NULL. In this case it returns 0 (via IsNULL()). I'm looking
through the SQL Language reference, but I'm not coming up with anything.
Thanks for your help,
kim
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
by Steve Halk » Thu, 01 Jul 1999 04:00:00
> Once again I need equivalent SQL behavior to an SQL Server query in
> ORACLE.
> The value in the select is the difference in dates unless the difference
> returns NULL. In this case it returns 0 (via IsNULL()). I'm looking
> through the SQL Language reference, but I'm not coming up with anything.
> Thanks for your help,
> kim
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
by Alan D. Mill » Thu, 01 Jul 1999 04:00:00
SELECT NVL(MyColumn, 0)
FROM MyTable
will return the value of column MyColumn if it's not null and 0 if the value
returned from the table is NULL. This is evaluated for each record.
Think of it as
IF MyColumn IS NULL THEN
return 0
ELSE
return MyColumn
END IF
type function.
HTH
Alan
>Once again I need equivalent SQL behavior to an SQL Server query in
>ORACLE.
>The value in the select is the difference in dates unless the difference
>returns NULL. In this case it returns 0 (via IsNULL()). I'm looking
>through the SQL Language reference, but I'm not coming up with anything.
>Thanks for your help,
>kim
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
by Valery Yourinsk » Thu, 01 Jul 1999 04:00:00
>The value in the select is the difference in dates unless the difference
>returns NULL. In this case it returns 0 (via IsNULL()). I'm looking
>through the SQL Language reference, but I'm not coming up with anything.
Valery Yourinsky
---
Softservice, Moscow
ORACLE PARTNER
tel/fax (095) 333-63-10, 128-18-21
http://www.softexpress.ru
ICQ# 368 97 94
by Mike Heis » Thu, 01 Jul 1999 04:00:00
This should return the value of the expression except when it is null it
will return 0.
Hopr this helps.
> Once again I need equivalent SQL behavior to an SQL Server query in
> ORACLE.
> The value in the select is the difference in dates unless the difference
> returns NULL. In this case it returns 0 (via IsNULL()). I'm looking
> through the SQL Language reference, but I'm not coming up with anything.
> Thanks for your help,
> kim
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
1. Directly substituting the value of a variable into sql query
Example of Query without variable:
SELECT *
FROM Accounts
INNER JOIN Patients ON
Accounts.ID=Patients.ID
Example of how I need Query to work with variable
substitution:
SELECT *
Accounts.ID=Patients.ID
Thanks for any suggestions.
2. sample ODBC driver with ACCESS
3. query help, substituting values
4. Assinging READTEXT result to a varchar
5. Null values: Classic null value problem (?)
9. NULL Values in SQL Queries - HELP HELP HELP...
10. NULL Values in SQL Queries - HELP!
11. NULL Values in SQL Queries - HELP HELP
12. check for null value in sql query