RE: dba_contraints.table_name

From: James Bullard <jbullard_at_onvia.com>
Date: Thu, 24 Aug 2000 07:02:04 -0700
Message-Id: <10599.115468@fatcity.com>

You can use a check constraint as part of a view creation.

James

-----Original Message-----
From: Lyall Barbour [mailto:lbarbour_at_stanford.edu] Sent: Wednesday, August 23, 2000 9:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: dba_contraints.table_name

How can you have a constraint on a view? That sounds weird to me. Is it possible? Anyone?

Lyall Barbour
At 07:22 AM 8/23/00 -0800, you wrote:
>Fyi, and probably you all know this already but I didn't,
>
>Dba_constraints has a column named table_name.
>
>That column doesn't just include tables, it includes views as well.
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
>Technology Services | Services technologiques
>Informatics Branch | Direction de l'informatique
>Maritimes Region, DFO | R=E9gion des Maritimes, MPO
>
>--
>Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

--=20
Author: Lyall Barbour
  INET: lbarbour_at_stanford.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).. Received on Thu Aug 24 2000 - 09:02:04 CDT