Re: Are DOMAINs part of SQL-99 standard?
Date: Fri, 4 Apr 2003 20:16:21 +0200
Message-ID: <1049480183.512763_at_exnews>
Hello Johann,
SQL Domains were added for the first time to SQL-92 and are very well described in SQL-99. In Oracle9iR2 the word DOMAIN isn't even a reserved word (used dictionary-view V$RESERVED_WORDS to check). The CREATE DOMAIN statement to create a named set of values failed with error "ORA-00901: invalid CREATE command". Besides, Oracle is an ANSI SQL/92 entry level compliant database.
Kind regards,
Markus Eltschinger
Swisscom IT Services Ltd
Data Warehouse Development
1752 Villars-Sur-Glāne FR
Switzerland
http://www.swisscom.com/it/content/index_EN.html
"Johann Sander" <jsander_at_puc-online.de> wrote in message
news:ff2b8f88.0304040728.137874cf_at_posting.google.com...
> Hi,
>
> I just came across somebody from DB2's technical support who said
> DOMAINs were not part of SQL-99 core.
>
> Is this true? I can't find any current references on the web to the
> SQL-99 standard. I also tried www.sql-99.org but was refused.
>
> He then went on and claimed no one of the big database vendors have
> integrated DOMAIN support in their products. Here I'd expect the
> opposite to be true. Anybody around who can tell something about
> DOMAINs in Oracle and SQL Server?
>
> Cheers, Johann
Received on Fri Apr 04 2003 - 20:16:21 CEST