| Title: | DEC Rdb against the World |
| Moderator: | HERON::GODFRIND |
| Created: | Fri Jun 12 1987 |
| Last Modified: | Thu Feb 23 1995 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1348 |
| Total number of notes: | 5438 |
Another interesting Oracle feature mentionned on Usenet : is it really true ?
/albert
From: [email protected] (Dave Cohen)
Subject: ORACLE Integrity Constraints
Organization: Data General Corporation, Research Triangle Park, NC
In "The Database Server Evaluation Guide" mailed by ORACLE to
prospective ORACLE OS/2 Server customers, integrity support
is described as follows :
Centrally Enforced Inetgrity :
The SQL dialect used by ORACLE Server includes syntactic support
for definition of referential and domain integrity constraints.
Semantic enforcement of constraints is not yet supported. Integrity
constraints are supported using the declarative model proposed
by ANSI as part of future SQL standards.
Am I missing something, or does this say that you can specify
referential and domain constraints in your data definitions,
but the database server will not do anything with them ?
David Cohen | I chose 'Please Do Not Send Main
[email protected] | Selection' this month in the
{world}!mcnc!rti!dg-rtp!cohend | 'Boss of the Month' Club.
Data General Corporation, RTP, NC|
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 604.1 | "not yet evaluated..." | SUOSW3::KAISER | working... | Fri Mar 30 1990 11:23 | 10 |
>> Am I missing something, or does this say that you can specify >> referential and domain constraints in your data definitions, >> but the database server will not do anything with them ? Your're absolutely right. Oracle even mentioned this in a sales seminar here in Stuttgart. They just store the information in their dictionary, but the database does not touch it afterwards. -Hans | |||||
| 604.2 | Oracle's reply | BEAGLE::GODFRIND | Would you trust Gorbatchev with SETPRV | Fri Mar 30 1990 12:56 | 19 |
Oracle's reply : From: [email protected] (Terry Greenlaw) Subject: Re: ORACLE Integrity Constraints Organization: Oracle Corporation, Belmont, CA [quotings deleted] Actually the constraints are kept in the data dictionary and can be referenced through your applications. They were put in version 6 so that app developers could design databases now that would use them in version 7. I also believe that SQL*Forms 3.0 uses some of the restraints when it generates your master-detail coordination triggers. I actually have used the integrity constraints before when I didn't have the entity-relationship diagram handy. Terry O. Greenlaw Sheathed within the Walkman, Staff Engineer Wear a halo of distortion. Oracle Corporation Aural contraceptive, [email protected] Aborting pregnant conversation - Marillion | |||||