Tables, Columns, and Rows
The table is the fundamental organizing unit in a database. There are several terminologies used, but generally we describe a table as having columns and rows. Let's take as an example a table designed to hold information about the CDs in our collection. There are a number of different pieces of information we would like to keep about each CD, such as artist, title, and release date. We call each of these a column, and we define them when we create the table.
As we start to enter data into our table, each item that we enter—in our example, the information for each CD—is called a row in the table.
Sometimes the columns in a table are called fields, and sometimes the rows are called records. In other words, for each CD, ...
Get Java™ Oracle® Database Development 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.
