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 -> Oracle 9i Numbers

Oracle 9i Numbers

From: <amerar_at_iwc.net>
Date: 8 Jul 2005 14:02:03 -0700
Message-ID: <1120856523.476042.149370@g14g2000cwa.googlegroups.com>

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 Received on Fri Jul 08 2005 - 16:02:03 CDT

Original text of this message

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