- 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