Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 8.1 "expression must have same datatype as corresponding expression"

Re: oracle 8.1 "expression must have same datatype as corresponding expression"

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 10 May 2006 18:35:55 +0200
Message-ID: <4462166b$0$295$626a54ce@news.free.fr>

"tk72" <t_karlsson72_at_hotmail.com> a écrit dans le message de news: 1147271259.910766.160370_at_g10g2000cwb.googlegroups.com...
| So it was THAT simple. I thought it couldn't convert NULL to a number,
| so I didn't even try that. Does Oracle 9i do that automatically
| "behind the scenes" or why does it work there?
|
| Thanks,
|
| TK
|

It seems there is such an implicit conversion or maybe there is multiple NULL one for each type :)

Regards
Michel Cadot Received on Wed May 10 2006 - 11:35:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US