Oracle Database 10g SQL (Osborne ORACLE Press Series)

In this chapter, you learned how to

• View the structure of a table

• Edit a SQL statement

• Save, retrieve, and run files containing SQL and SQL*Plus commands

• Format column output and set the page and line sizes

• Use variables in SQL*Plus

• Create simple reports

• Write SQL statements that generate other SQL statements

In the next chapter, you ll learn how to nest one query within another. The nested query is known as a subquery.