Re: Oracle 9i Numbers

From: Dave <x_at_x.com>
Date: Fri, 08 Jul 2005 22:18:20 GMT
Message-ID: <MYCze.65972$G8.34927@text.news.blueyonder.co.uk>

<amerar_at_iwc.net> wrote in message
news:1120856523.476042.149370_at_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
>

no its not true, you can still do it Received on Fri Jul 08 2005 - 17:18:20 CDT