Re: Are DOMAINs part of SQL-99 standard?

From: Eltschinger Markus <do_not_mail_at_test.com>
Date: Fri, 4 Apr 2003 20:16:21 +0200
Message-ID: <1049480183.512763@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 - 12:16:21 CST