Database Reference
In-Depth Information
•
Queries Involving Set Operators
•
Queries With Runtime Variables
•
Queries Involving SQL Plus Format Commands
7.
Differentiate between embedded SQL code and dynamic SQL
code. Describe a scenario that would warrant the use of each.
12.18 References and/or Recommended
Readings
[Connolly, 2002] Connolly, Thomas and Carolyn Begg.
Database Systems: A Practical
Approach to Design, Implementation and Management
3
rd
ed. New York, NY:
Addison-Wesley, 2002. See Chapters 20 and 21.
[Couchman, 1999] Couchman, Jason and Christopher Allen.
Oracle Certified Professional:
Application Developer Guide
. New York, NY: Osborne/McGraw-Hill, 1999. See Chapters 1,
2, 5 and 6.
[Elmasri, 2007] Elmasri, Ramez and Shamkant B. Navathe.
Fundamentals of Database
Systems
5
th
ed. Reading, MA: Addison-Wesley, 2007. See Chapters 8 and 9.
[Garcia-Molina, 2002] Garcia-Molina, Hector, Jeffrey Ullman and Jennifer Widom.
Database Systems: The Complete Book
. Upper Saddle River, NJ: Prentice Hall, 2002.
See Chapter 6.
[Martin, 1995] Martin, James, and Joe Leben.
Client/Server Databases: Enterprise
Computing
. Upper Saddle River, NJ: Prentice Hall, 1995. See Chapters 16-18.
[Oracle, 2008] Oracle Corporation.
SQL Reference
.
http://www.oracle.com/technology/
index.html
(accessed October 2008).
[Rob, 2007] Rob, Peter and Carlos Coronel.
Database Systems: Design, Implementation &
Management
7
th
ed. Boston, MA: Course Technology, 2007. See Chapter 8.
[Shah, 2002] Shah, Nilesh.
Database Systems Using Oracle: A Simplified Guide to SQL and
PL/SQL
. Upper Saddle River, NJ: Prentice Hall, 2002. See Chapters 5 - 12.
[Ullman, 1997] Ullman, Jeffrey D., and Jennifer Widom.
A First Course in Database
Systems
. Upper Saddle River, NJ: Prentice Hall, 1997. See Chapter 5.