Re: Oracle 9i Numbers

From: Jason F. <jason_nospam_at_buildertech.ca>
Date: Sun, 10 Jul 2005 17:12:25 GMT
Message-ID: <ZFcAe.87803$wr.40926@clgrps12>

amerar_at_iwc.net wrote:

>
> Hi All,
>
> In Oracle 8i, I believe that if you have a column defined at NUMBER,
> you can still create an insert statement with the number enclosed in
> quotes, and it will insert correctly.
>
> INSERT INTO table_a '50';
>
> However, I've heard that this is no longer true in 9i. We are thinking
> of moving to 9i......can anyone verify this for me???

You are referring to implicit datatype conversions. Oracle will convert inserted/updated values to the datatype of the column, this hasn't changed since 8i. It's recommended that you don't rely on implicit conversions because it impacts performance and readability, and in some cases does not give predictable results. Received on Sun Jul 10 2005 - 12:12:25 CDT