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.