Methods of Storing Data
There are several different methods of storing data in tables in the database. These methods are covered in this section. From the user's perspective, however, all appear the same, and all the different storage options provide the same functionality. From the user's perspective, SELECT, INSERT, UPDATE, or DELETE all appear to function in the same way.
Regular Tables
A regular table, or more commonly just a table, is the most commonly used method of storing user data in a typical Oracle database. It is the default method used and is also the main focus for this chapter. Database administrators have little control over how the rows are distributed in a regular table, and users have even less. Rows are stored randomly in ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
