Re: Foreign key in Oracle Sql

-CELKO- wrote:

> In non-Oracle product that have implemented ANSI/ISO standards
> properly, the ALTER TABLE statements (not commands) are a problem.
> They have to trigger a total validation of the schema to be sure that
> **all of the constraints** are still valid after the ALTER.
>
> The preferred method is to declare the tables in a single CREATE SCHEMA
> with all of the constraints in place on each table.
>
> Oracle is still a sequential file structure with sequential creation,
> failure to conform to even SQL-92 standards. I still marvel that Larry
> E. can sell it to people.

Excuse me but exactly where did you get your information? The following works just fine in Oracle.

CREATE SCHEMA AUTHORIZATION uwclass
CREATE TABLE t1
(tid NUMBER(10) PRIMARY KEY, last_name VARCHAR2(20)) CREATE TABLE t2
(tid NUMBER(10) PRIMARY KEY, last_name VARCHAR2(20)) CREATE VIEW t1t2_view
AS SELECT t1.tid, t2.last_name FROM t1, t2 WHERE t1.tid = t2.tid GRANT select ON t1t2_view TO system;

That developers and DBAs don't use it is hardly the product's fault.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---