Storing and Maintaining Data
Data in a relational database (such as the Oracle database) is stored in tables. A very simple sales database, for example, might have four tables that store data on products, customers, suppliers, and customer orders.
When you add a record of data into a table, the record is stored as a row of the table. A record has fields. A product record, for example, might have four fields: product code, name, price, and launch date. All records you store in the product table must have the same fields. Each of the fields is a column of the table.
This chapter shows you how to use SQL statements to store and maintain data. The main objective of this chapter is to give you a taste of working with SQL.
To test the book ...