- Shopping Bag ( 0 items )
-
All (9) from $1.99
-
Used (9) from $1.99
Ships from: College Park, MD
Usually ships in 1-2 business days
Ships from: Fort Mill, SC
Usually ships in 1-2 business days
Ships from: Konawa, OK
Usually ships in 1-2 business days
Ships from: STATEN ISLAND, NY
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
Written for readers who already know the basics of computers--they just need to learn Oracle--this book skips the fluff to deliver straightforward, insightful direction. Readers will learn how to interact with the Oracle RDBMS, write Oracle applications, and create and maintain data.
| Acknowledgments | ||
| About the Author | ||
| Introduction | ||
| 1 | Introduction to the Oracle Relational Database | 3 |
| 2 | Logical Database Storage Structures | 11 |
| 3 | Database Design | 21 |
| 4 | Datatypes | 31 |
| 5 | Tables | 43 |
| 6 | Synonyms | 53 |
| 7 | Indexes and Sequences | 59 |
| 8 | Views | 67 |
| 9 | Snapshots | 73 |
| 10 | Structured Query Language (SQL) | 83 |
| 11 | SQL Operators and Conditions | 91 |
| 12 | SQL Commands | 99 |
| 13 | Functions | 113 |
| 14 | Advanced Functions | 127 |
| 15 | Joins and Unions | 139 |
| 16 | Selecting and Maintaining Data | 149 |
| 17 | Cursors | 159 |
| 18 | Formatting Query Results with SQL[superscript *] Plus | 167 |
| 19 | Additional SQL[superscript *] Plus Commands | 179 |
| 20 | Data Integrity | 191 |
| 21 | Transactions | 201 |
| 22 | PL/SQL | 211 |
| 23 | PL/SQL Structures | 223 |
| 24 | Packages | 233 |
| 25 | Triggers | 243 |
| 26 | Stored Procedures | 251 |
| 27 | Import and Export | 263 |
| 28 | SQL[superscript *] Loader | 273 |
| 29 | SQL[superscript *] DBA | 283 |
| 30 | Managing Database Users | 295 |
| 31 | Roles | 303 |
| 32 | Privileges | 311 |
| 33 | Auditing the Database | 321 |
| 34 | Backup and Recovery | 331 |
| 35 | Understanding Server Messages and Codes | 343 |
| 36 | Handling Runtime Exceptions in PL/SQL | 359 |
| 37 | Tuning SQL Statements | 371 |
| 38 | Tuning Applications | 381 |
| 39 | MTSs, Locks, and Links | 391 |
| 40 | Distributed Databases and Processes | 399 |
| 41 | The Optimizer | 409 |
| Appendixes | 419 | |
| App. A Oracle Products | 421 | |
| App. B Oracle SQL Reserved Words | 427 | |
| App. C SQL[superscript *] Loader Reserved Words | 433 | |
| App. D SQL[superscript *] DBA Reserved Words | 437 | |
| App. E PL/SQL Reserved Words | 443 | |
| App. F SQL[superscript *] Plus Reserved Words | 451 | |
| Index | 455 |
Overview