![Page 1: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/1.jpg)
Database Programming - Section 10 Student Guide
![Page 2: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/2.jpg)
![Page 3: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/3.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page i
Table of Contents
Database Programming - Section 10..............................................................................................................1 Lesson 1 - Defining NOT NULL and UNIQUE Constraints.........................................................................1 What Will I Learn? ........................................................................................................................................2 Why Learn It?................................................................................................................................................3 Tell Me / Show Me........................................................................................................................................4 Try It / Solve It ..............................................................................................................................................13 Lesson 2 - PRIMARY KEY, FOREIGN KEY, and CHECK Constraints.....................................................15 What Will I Learn? ........................................................................................................................................16 Why Learn It?................................................................................................................................................17 Tell Me / Show Me........................................................................................................................................18 Try It / Solve It ..............................................................................................................................................27 Lesson 3 - Managing Constraints ..................................................................................................................30 What Will I Learn? ........................................................................................................................................31 Why Learn It?................................................................................................................................................32 Tell Me / Show Me........................................................................................................................................33 Try It / Solve It ..............................................................................................................................................44 Lesson 4 - Practice Exercises and Review.....................................................................................................48 What Will I Learn? ........................................................................................................................................49 Why Learn It?................................................................................................................................................50 Tell Me / Show Me........................................................................................................................................51 Try It / Solve It ..............................................................................................................................................52 Lesson 5 - Practice Exercises and Quiz .........................................................................................................54 What Will I Learn? ........................................................................................................................................55 Why Learn It?................................................................................................................................................56 Tell Me / Show Me........................................................................................................................................57 Try It / Solve It ..............................................................................................................................................58
![Page 4: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/4.jpg)
![Page 5: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/5.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 1
Lesson 1 - Defining NOT NULL and UNIQUE Constraints
Lesson 1 - Defining NOT NULL and UNIQUE Constraints
![Page 6: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/6.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 2
What Will I Learn?
What Will I Learn?
![Page 7: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/7.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 3
Why Learn It?
Why Learn It?
![Page 8: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/8.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 4
Tell Me / Show Me
Tell Me / Show Me
![Page 9: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/9.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 5
Tell Me / Show Me
Tell Me / Show Me
![Page 10: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/10.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 6
Tell Me / Show Me
Tell Me / Show Me
![Page 11: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/11.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 7
Tell Me / Show Me
Tell Me / Show Me
![Page 12: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/12.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 8
Tell Me / Show Me
Tell Me / Show Me
![Page 13: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/13.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 9
Tell Me / Show Me
Tell Me / Show Me
![Page 14: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/14.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 10
Tell Me / Show Me
Tell Me / Show Me
![Page 15: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/15.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 11
Tell Me / Show Me
Tell Me / Show Me
![Page 16: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/16.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 12
Tell Me / Show Me
Tell Me / Show Me
![Page 17: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/17.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 13
Try It / Solve It
Try It / Solve It
![Page 18: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/18.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 14
Try It / Solve It
Try It / Solve It
![Page 19: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/19.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 15
Lesson 2 - PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
Lesson 2 - PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
![Page 20: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/20.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 16
What Will I Learn?
What Will I Learn?
![Page 21: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/21.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 17
Why Learn It?
Why Learn It?
![Page 22: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/22.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 18
Tell Me / Show Me
Tell Me / Show Me
![Page 23: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/23.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 19
Tell Me / Show Me
Tell Me / Show Me
![Page 24: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/24.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 20
Tell Me / Show Me
Tell Me / Show Me
![Page 25: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/25.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 21
Tell Me / Show Me
Tell Me / Show Me
![Page 26: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/26.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 22
Tell Me / Show Me
Tell Me / Show Me
![Page 27: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/27.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 23
Tell Me / Show Me
Tell Me / Show Me
![Page 28: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/28.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 24
Tell Me / Show Me
Tell Me / Show Me
![Page 29: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/29.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 25
Tell Me / Show Me
Tell Me / Show Me
![Page 30: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/30.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 26
Tell Me / Show Me
Tell Me / Show Me
![Page 31: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/31.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 27
Try It / Solve It
Try It / Solve It
![Page 32: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/32.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 28
Try It / Solve It
Try It / Solve It
![Page 33: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/33.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 29
Try It / Solve It
Try It / Solve It
![Page 34: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/34.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 30
Lesson 3 - Managing Constraints
Lesson 3 - Managing Constraints
![Page 35: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/35.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 31
What Will I Learn?
What Will I Learn?
![Page 36: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/36.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 32
Why Learn It?
Why Learn It?
![Page 37: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/37.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 33
Tell Me / Show Me
Tell Me / Show Me
![Page 38: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/38.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 34
Tell Me / Show Me
Tell Me / Show Me
![Page 39: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/39.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 35
Tell Me / Show Me
Tell Me / Show Me
![Page 40: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/40.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 36
Tell Me / Show Me
Tell Me / Show Me
![Page 41: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/41.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 37
Tell Me / Show Me
Tell Me / Show Me
![Page 42: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/42.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 38
Tell Me / Show Me
Tell Me / Show Me
![Page 43: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/43.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 39
Tell Me / Show Me
Tell Me / Show Me
![Page 44: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/44.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 40
Tell Me / Show Me
Tell Me / Show Me
![Page 45: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/45.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 41
Tell Me / Show Me
Tell Me / Show Me
![Page 46: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/46.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 42
Tell Me / Show Me
Tell Me / Show Me
![Page 47: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/47.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 43
Tell Me / Show Me
Tell Me / Show Me
![Page 48: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/48.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 44
Try It / Solve It
Try It / Solve It
![Page 49: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/49.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 45
Try It / Solve It
Try It / Solve It
![Page 50: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/50.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 46
Try It / Solve It
Try It / Solve It
![Page 51: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/51.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 47
Try It / Solve It
Try It / Solve It
![Page 52: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/52.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 48
Lesson 4 - Practice Exercises and Review
Lesson 4 - Practice Exercises and Review
![Page 53: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/53.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 49
What Will I Learn?
What Will I Learn?
![Page 54: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/54.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 50
Why Learn It?
Why Learn It?
![Page 55: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/55.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 51
Tell Me / Show Me
Tell Me / Show Me
![Page 56: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/56.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 52
Try It / Solve It
Try It / Solve It
![Page 57: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/57.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 53
Try It / Solve It
Try It / Solve It
![Page 58: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/58.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 54
Lesson 5 - Practice Exercises and Quiz
Lesson 5 - Practice Exercises and Quiz
![Page 59: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/59.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 55
What Will I Learn?
What Will I Learn?
![Page 60: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/60.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 56
Why Learn It?
Why Learn It?
![Page 61: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/61.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 57
Tell Me / Show Me
Tell Me / Show Me
![Page 62: Student Guide Database Programming - Section 10 - Oracleacademy.oracle.com/.../Database_Programming_-_Section_10_Stud… · Title: Microsoft Word - Database_Programming_-_Section_10.doc](https://reader031.vdocuments.us/reader031/viewer/2022022519/5b15bb8b7f8b9a8b288dbae8/html5/thumbnails/62.jpg)
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 10 Page 58
Try It / Solve It
Try It / Solve It