Home arrow Oracle arrow Page 3 - Working With Oracle on Windows: Part 2
ORACLE

Working With Oracle on Windows: Part 2


Now we have installed Oracle we can now begin to familiarise ourselves with use of SQL and how to use basic Oracle expressions.

Author Info:
By: Ben Shepherd
Rating: 4 stars4 stars4 stars4 stars4 stars / 17
March 04, 2003
TABLE OF CONTENTS:
  1. · Working With Oracle on Windows: Part 2
  2. · Databases
  3. · Relationships
  4. · Structuring your database
  5. · Tables in Oracle
  6. · User Defined Schema Objects
  7. · Conclusion

print this article
SEARCH DEVARTICLES

Working With Oracle on Windows: Part 2 - Relationships
(Page 3 of 7 )

Why use more than one table? Well the answer is simple. Using relational databases - i.e. a database with two or more tables related to one another) - reduces the time wasted waiting for query once executed, it is easier to manage and much easier to enter data.

The three types of relationships are as follows,

One-to-one - One record in a table is related to only one record in another table.

One-to-many - One record in a table can be related to many records in another table.

Many-to-many - One record in a table can be related to one or more records in another table, and one or more records in the second table can be related to one or more records in the first table.


blog comments powered by Disqus
ORACLE ARTICLES

- Oracle Purchases Taleo to Extend Cloud Compu...
- Partitioning in Oracle. What? Why? When? Who...
- Datatypes Used in Oracle 9i
- Creating a Database in Oracle 9i
- Oracle with Doctor Janusz Getta
- Working With Oracle on Windows: Part 3
- Working With Oracle on Windows: Part 2

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials