O'Reilly logo

Oracle SQL: A Beginner’s Tutorial by Djoni Darmawikarta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required