Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!51g2000cwl.googlegroups.com!not-for-mail
From: "Anurag Varma" <avoracle@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Is this a bug?
Date: 4 Jan 2007 08:31:45 -0800
Organization: http://groups.google.com
Lines: 63
Message-ID: <1167928304.818205.166480@51g2000cwl.googlegroups.com>
References: <1167853573.172687.246190@i12g2000cwa.googlegroups.com>
   <1167854463.775447.38350@n51g2000cwc.googlegroups.com>
   <1167862701.878511.317540@s34g2000cwa.googlegroups.com>
   <1167866459.800948@bubbleator.drizzle.com>
   <1167924644.781898.142480@i15g2000cwa.googlegroups.com>
   <459D26BB.2060305@arcor.de>
NNTP-Posting-Host: 13.13.137.1
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1167928312 2148 127.0.0.1 (4 Jan 2007 16:31:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 4 Jan 2007 16:31:52 +0000 (UTC)
In-Reply-To: <459D26BB.2060305@arcor.de>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 51g2000cwl.googlegroups.com; posting-host=13.13.137.1;
   posting-account=Bjij0w0AAACWMZ9jVkCMjBKLT0Yf1PAH
Xref: news.f.de.plusline.net comp.databases.oracle.server:191709


Maxim Demenko wrote:
> Anurag Varma schrieb:
>
> > The bug (or inconsistency as you might want to call it) is that oracle
> > should
> > not allow a column name and datatype to be of the same name IF the
> > column
> > name is not enclosed in double quotes.
> >
> > So create table test (timestamp timestamp); should throw an error
> > since all other datatypes do throw an error.
> >
>
> You are far too optimistic ;-)
>
> scott@ORA102> create table t(id number,bfile bfile);
>
> Table created.
>
> scott@ORA102> drop table t;
>
> Table dropped.
>
> scott@ORA102> create table t(id number,clob clob);
>
> Table created.
>
> scott@ORA102> drop table t;
>
> Table dropped.
>
> scott@ORA102> create table t(id number,blob blob);
>
> Table created.
>
> scott@ORA102> drop table t;
>
> Table dropped.
>
> scott@ORA102> create table t(id number,nchar nchar);
>
> Table created.
>
> scott@ORA102> drop table t;
>
> Table dropped.
>
>
> In all the cases behaviour with plsql units referencing the table is
> identical to those with timestamp...
> 
> Best regards
> 
> Maxim


Thanks for the correction.

:)

Anurag