Tài liệu Mastering Oracle SQL and SQL*Plus

Foreword . ix
About the Author . xi
About the Technical Reviewers xiii
Acknowledgments . xv
Introduction . xvii
CHAPTER 1 Relational Database Systems and Oracle . 1
CHAPTER 2 Introduction to SQL, iSQL*Plus, and SQL*Plus 25
CHAPTER 3 Data Definition, Part I . 65
CHAPTER 4 Retrieval: The Basics 77
CHAPTER 5 Retrieval: Functions 113
CHAPTER 6 Data Manipulation 141
CHAPTER 7 Data Definition, Part II 159
CHAPTER 8 Retrieval: Multiple Tables and Aggregation 191
CHAPTER 9 Retrieval: Some Advanced Features 233
CHAPTER 10 Views 265
CHAPTER 11 SQL*Plus and iSQL*Plus . 289
CHAPTER 12 Object-Relational Features . 327
APPENDIX A Quick Reference to SQL and SQL*Plus 349
APPENDIX B Data Dictionary Overview 373
APPENDIX C The Seven Case Tables . 381
APPENDIX D Answers to the Exercises 393
APPENDIX E Oracle Documentation,Web Sites, and Bibliography . 443
INDEX . 449