Re: Call for an API standard for SQL statements

From: Brian Inglis <Brian.Inglis_at_SystematicSW.Invalid>
Date: Sat, 23 Oct 2004 16:44:21 GMT
Message-ID: <bp1ln09br27kqkvvs7gpp2qt7glu82bto3_at_4ax.com>


On Fri, 22 Oct 2004 10:15:07 -0400 in comp.databases.theory, "Laconic2" <laconic2_at_comcast.net> wrote:

>
>"Fredrik Bertilsson" <fredrik_bertilsson_at_passagen.se> wrote in message
>news:31f7e57d.0410212122.3478aaa4_at_posting.google.com...
>> "Laconic2" <laconic2_at_comcast.net> wrote:
>> > Do you really need custom datatypes, or just custom domains?
>> There are no database vendor-independent domain concept.
>
>SQL-92 includes the CREATE DOMAIN statement, doesn't it? Isn't that a
>vendor independent domain concept?
>
>viz:
>http://developer.mimer.com/documentation/html_82/Mimer_SQL_Reference_Manual/
>SQL_Statements31.html
>
>> > Does your DBMS support CREATE DOMAIN? If not, why not?
>> I know that RDB support this, but Oracle does not.
>
>More's the pity. When I moved from Rdb to Oracle in 1994, the lack of
>CREATE DOMAIN was my biggest lament.
>I wonder when Oracle is going to add CREATE DOMAIN to RDBMS?

Oracle added CREATE OR REPLACE TYPE t AS OBJECT ( ... ) in 9i. ... can be attributes or methods.

-- 
Thanks. Take care, Brian Inglis 	Calgary, Alberta, Canada

Brian.Inglis_at_CSi.com 	(Brian[dot]Inglis{at}SystematicSW[dot]ab[dot]ca)
    fake address		use address above to reply
Received on Sat Oct 23 2004 - 18:44:21 CEST

Original text of this message