Oracle SQL Interactive Workbook

Front Cover
Prentice Hall Professional, 2003 - Computers - 851 pages
3 Reviews
Oracle SQL Interactive Workbook, Second Edition is the only integrated book-and-Web learning solution that teaches all the Oracle 9i SQL skills you need, hands on, through labs, exercises, and projects-complete with a Web-based training site! Fully updated for Oracle 9i, author Alice Rischert covers all types of joins (including the new ANSI join syntax); SQL functions; subqueries set operators; sequences, views, and indexes; data dictionary; dynamic SQL; security; optimization; the SQL*Plus and iSQL*Plus environments; and much more.
 

What people are saying - Write a review

User Review - Flag as inappropriate

thank's
but if u preview all the pages.

User Review - Flag as inappropriate

thanks
it's a very useful book for me...............

Contents

SQL and Data I
2
2 Table Relationships
15
3 The Student Schema Diagram
37
TestYourThinking
50
2 The Anatomy of a SELECT Statement
68
3 Editing a SQL Statement
80
Comparison and Logical Operators
96
5 The ORDER BY Clause I 14
114
Test Your Thinking
405
2 SelfJoins
428
Test Your Thinking
438
2 Updating and Deleting Data
463
Test Your Thinking
490
1 2 Altering Tables and Manipulating Constraints
522
I TestYourThinking
545
2 Indexes
563

TestYourThinking
124
2 Number Functions
148
3 Miscellaneous SingleRow Functions
156
TestYourThinking
177
2 Performing Date and Time Math
200
3 Using the New Oracle 9i DATETIME Datatypes
208
4 Performing Calculations with the INTERVAL Datatype
232
5 Converting from One Datatype to Another
242
TestYourThinking
255
2 The GROUP BY and HAVING Clauses
266
TestYourThinking
279
2 Joining Three or More Tables
301
TestYourThinking
320
2 Correlated Subqueries
339
3 Inline Views Scalar Subquery Expressions
356
4 ANY SOME and ALL Operators in Subqueries
375
Test Your Thinking
384
2 The MINUS and INTERSECT Set Operators
396
3 Sequences
582
TestYourThinking
588
2 Dynamic SQL Scripts
606
TestYourThinking
629
Security
631
TestYourThinking
661
2 ROLLUP and CUBE Operators
698
3 Hierarchical Queries
720
TestYourThinking
737
TestYourThinking
778
APPENDIX B SQL Formatting Guide
799
Student Database Schema
815
APPENDIX E Table and Column Descriptions
817
APPENDIX F Additional Example Tables
825
APPENDIX G Navigating through the Oracle
833
APPENDIX H Resources
839
Copyright

Other editions - View all

Common terms and phrases

About the author (2003)

ALICE RISCHERT chairs the Database Application Development and Design track at the Computer Technology and Application Program at Columbia University. She has taught Oracle SQL to hundreds of students and has presented at Oracle conferences. Rischert has worked with Oracle for over 10 years and currently consults on large Oracle data warehouse and system integration projects.

Foreword by Peter Koletze

Bibliographic information