Re: Oracle 9i Numbers

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???
>
> Thanks,
>
> Arthur

SQL*Plus: Release 10.1.0.4.0 - Production on Fri Jul 8 14:15:52 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> create table t (

   2 numbercol NUMBER(5));

Table created.

SQL> INSERT INTO t VALUES ('123');

1 row created.

SQL> SELECT * FROM t;

  NUMBERCOL

        123

SQL> That it still works doesn't make it a really bad idea.

Why would you care whether Oracle is still allowing a bad practice? Just stop doing it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)