Sams Teach Yourself SQL in 21 Days, Fourth Edition

Q&A

Q1:	How do I decide when to issue statements manually and when to write SQL to generate SQL?
A1:	Ask yourself these questions: How often will I be issuing the statements in question? Will it take me longer to write the “parent” statement than it would to issue each statement manually?
Q2:	From which tables may I select to generate SQL statements?
A2:	You may select from any tables to which you have access, whether they are tables that you own or tables that reside in the data dictionary. Also keep in mind that you can select from any valid object in your database, such as views or snapshots.
Q3:	Are there any limits to the statements that I can generate with SQL?
A3:	For the most part, any statement that you can write manually can be generated ...