student guide database programming - section 13...
TRANSCRIPT
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page i
Table of Contents
Database Programming - Section 13..............................................................................................................1 Lesson 1 - Practice Exercises and Review.....................................................................................................1 What Will I Learn? ........................................................................................................................................2 Why Learn It?................................................................................................................................................3 Tell Me / Show Me........................................................................................................................................4 Try It / Solve It ..............................................................................................................................................5 Lesson 2 - Putting It All Together .................................................................................................................11 What Will I Learn? ........................................................................................................................................12 Why Learn It?................................................................................................................................................13 Tell Me / Show Me........................................................................................................................................14 Try It / Solve It ..............................................................................................................................................15 Lesson 3 - Creating and Revoking Object Privileges ....................................................................................17 What Will I Learn? ........................................................................................................................................18 Why Learn It?................................................................................................................................................19 Tell Me / Show Me........................................................................................................................................20 Try It / Solve It ..............................................................................................................................................34 Lesson 4 - Practice Exercises ........................................................................................................................36 What Will I Learn? ........................................................................................................................................37 Why Learn It?................................................................................................................................................38 Tell Me / Show Me........................................................................................................................................39 Try It / Solve It ..............................................................................................................................................40 Lesson 5 - Practice Exercises and Quiz .........................................................................................................50 What Will I Learn? ........................................................................................................................................51 Why Learn It?................................................................................................................................................52 Tell Me / Show Me........................................................................................................................................53 Try It / Solve It ..............................................................................................................................................54
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 1
Lesson 1 - Practice Exercises and Review
Lesson 1 - Practice Exercises and Review
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 2
What Will I Learn?
What Will I Learn?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 3
Why Learn It?
Why Learn It?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 4
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 5
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 6
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 7
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 8
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 9
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 10
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 11
Lesson 2 - Putting It All Together
Lesson 2 - Putting It All Together
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 12
What Will I Learn?
What Will I Learn?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 13
Why Learn It?
Why Learn It?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 14
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 15
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 16
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 17
Lesson 3 - Creating and Revoking Object Privileges
Lesson 3 - Creating and Revoking Object Privileges
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 18
What Will I Learn?
What Will I Learn?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 19
Why Learn It?
Why Learn It?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 20
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 21
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 22
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 23
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 24
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 25
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 26
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 27
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 28
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 29
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 30
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 31
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 32
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 33
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 34
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 35
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 36
Lesson 4 - Practice Exercises
Lesson 4 - Practice Exercises
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 37
What Will I Learn?
What Will I Learn?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 38
Why Learn It?
Why Learn It?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 39
Tell Me / Show Me
Tell Me / Show Me
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 40
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 41
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 42
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 43
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 44
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 45
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 46
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 47
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 48
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 49
Try It / Solve It
Try It / Solve It
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 50
Lesson 5 - Practice Exercises and Quiz
Lesson 5 - Practice Exercises and Quiz
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 51
What Will I Learn?
What Will I Learn?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 52
Why Learn It?
Why Learn It?
Copyright © Oracle, 2004. All rights reserved.
Database Programming - Section 13 Page 53
Tell Me / Show Me
Tell Me / Show Me