|
Week Seven, October 20th - October 26th Find a web site that discusses how Oracle reinforces integrity in an Oracle database and how integrity helps protect the data. Once a colleague of yours uses a site, you cannot use that link and expect to receive participation credit for a repeated link. Oracle reinforces data integrity by using what are called data constraints. The data constraints Oracle uses are NOT NULL UNIQUE CHECK PRIMARY KEY FOREIGN
KEY ENABLE DISABLE VALIDATE NOVALIDATE
Data integrity becomes important when queries must be run. Without data integrity any reports or queries will contain data that is invalid or of a dataset that is incomplete.
My website is: http://www.ss64.com/orasyntax/12constraints.html
Classmates Websites:
http://www.dba-oracle.com/art_builder_ri.htm http://www-rohan.sdsu.edu/doc/oracle/server803/A54643_01/ch7.htm http://oracle.ittoolbox.com/press/disppress.asp?i=82178&t=4&a=Oracle http://www.stanford.edu/dept/itss/docs/oracle/9i/appdev.920/a96590/adg05itg.htm http://www.rbsbooks.com/lopchap6.htm http://databasejournal.com/features/oracle/article.php/308329 -- Mosley
|
|
Home | Photos | WaterMark Multimedia | Online Shopping Outlet Matt's Bio | UMUC | Feedback | Guest book | E-mail me
FaulknerWeb.com is designed and managed by Matt Faulkner. Domain Name service provided by Namesecure Web
Service by eDataRack |