Practical Guide To Using SQL In Oracle

Practical Guide To Using SQL In Oracle

by Dr. Richard Earp, Dr. Sikha Bagui
     
 

binding type PBSee more details below

Overview

binding type PB

Product Details

ISBN-13:
9781598220636
Publisher:
Jones & Bartlett Learning
Publication date:
08/22/2008
Pages:
485
Sales rank:
594,540
Product dimensions:
6.00(w) x 8.90(h) x 1.10(d)

Table of Contents

Prologue: The Software Engineering Process and Relational Databases 1

Ch. 1 Getting Started with Oracle 25

Ch. 2 More "Beginning" SQL Commands 63

Ch. 3 Joins 111

Ch. 4 Functions 145

Ch. 5 Query Development, Privileges, and Derived Structures 175

Ch. 6 Set Operations 205

Ch. 7 Subqueries versus Joins 227

Ch. 8 GROUP BY and HAVING 247

Ch. 9 Correlated Subqueries 269

Ch. 10 CREATE TABLE and SQLLOADER 307

Ch. 11 Multiple Commands, START Files, and Reports in SQLPLUS 335

Ch. 12 Beginning PL/SQL: Anonymous Blocks, Procedures, Functions, and Packages 361

Ch. 13 Introdudion to Triggers 387

Ch. 14 SQL and XML 405

Appendix A Some UNIX Commands 421

Appendix B The Data Dictionary 429

Appendix C The Student Database and Other Tables Used in This Book 447

Appendix D Glossary of Terms 453

Appendix E Important Commands and Functions 467

Index 479

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >