Oracle SQL Recipes A Problem-Solution Approach

Contents at a Glance
„Contents ..................................................................................................................... vii
„About the Authors ................................................................................................... xviii
„About the Technical Reviewer .................................................................................. xix
„Acknowledgments .................................................................................................... xxi
„Introduction ............................................................................................................ xxiii
PART 1 „ „ „ Foundation of Data Manipulation ...................................................... 1
„Chapter 1: The Basics .................................................................................................. 3
„Chapter 2: Summarizing and Aggregating Data ........................................................ 23
„Chapter 3: Querying from Multiple Tables ................................................................. 59
„Chapter 4: Creating and Deriving Data ...................................................................... 83
„Chapter 5: Common Query Patterns ........................................................................ 109
PART 2 „ „ „ Data Types and Their Problems .................................................... 141
„Chapter 6: Working with Date and Time Values ...................................................... 143
„Chapter 7: Strings .................................................................................................... 167
„Chapter 8: Working with Numbers .......................................................................... 187
PART3 „ „ „ Your Development Environment .................................................... 207
„Chapter 9: Managing Transactions .......................................................................... 209
„Chapter 10: Data Dictionary ..................................................................................... 229


Another Database Books
Download