example, expresses nothing by itself. To what person or business does it belong? The postal code field is informative only after it is associated with other data. In Oracle, the fields relating to a particular person, thing, or event are bundled together to form a single, complete unit of data, called a record (it can also be referred to as a row or an occurrence). Each record is made up of a number of fields. No two fields in a record can have the same field name. During an Oracle database design project, the analysis of your business needs identifies all the fields or attributes of interest. If your business needs change over time, you define any additional fields or change the definition of existing fields. Oracle TablesOracle stores records relating to each other in a table. For example, all the records for employees of a company would be stored by Oracle in one table, the employee table. A table is easily visualized as a tabular arrangement of data, not unlike a spreadsheet, consisting of vertical columns and horizontal rows. +---------------------------------------------------------------------------+| EMPLOYEE |+-----------+--------------+--------------+--------+-------------+----------+| EMPL_ID | NAME_FIRST | NAME_LAST | DEPT | POSITION | SALARY |+-----------+--------------+--------------+--------+-------------+----------+| 1 | Horace | Slate | 1 | Owner | 29 || 4 | Fred | Flintstone | 2 | Excavator | 13 || 5 | Barney | Rubble | 2 | Laborer | 12 || 7 | Joe | Rockhead | 3 | Laborer | 11 || 11 | Shelly | Gravel | 1 | Secretary | 12 |+-----------+--------------+--------------+--------+-------------+----------+A table consists of a number of records. The field names of each record in ...
