|
 |
|
Oracle Tips by Burleson |
Basic SQL
The SQL language has three types of operations
that allow you to manipulate the tables in any way you want.
– Gets
the rows that you want: The select operator shrinks the table
vertically. In the example below, the “*” means to select all columns,
and the WHERE
clause removes rows that we don’t want to see:
–
Chooses the columns you want to see. Shrinks the table
horizontally:
– Joins the
table together, based on their common keys:
Now that we understand the basics of tables, let’s
take a look at how tables are designed. We don’t need to know
all of the details, but it’s important to understand how tables are
structured.
The above book excerpt is from:
Easy Oracle
SQL
Get Started
Fast writing SQL Reports with SQL*Plus
ISBN 0-9727513-7-8
Col. John Garmany
http://www.rampant-books.com/book_2005_1_easy_sql.htm |
