Oracle SQL and Pl/SQL handbook : a guide for data administrators, developers, and business analysts / John Adolph Palinski.
Material type: TextPublication details: Boston, [Mass.] ; London : Addison-Wesley, 2002.Description: 432 p. ; 24 cmISBN:- 9780201752946 (pbk.) :
- 0201752948 (alk. paper)
- 005.7565 PAL
- QA76.73.S67
Item type | Current library | Call number | Vol info | Copy number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|---|
Long Loan | TUS: Midlands, Main Library Athlone CD | 005.7565 PAL (Browse shelf(Opens below)) | CD 323 | 1 | Available | 120783 | ||
Long Loan | TUS: Midlands, Main Library Athlone CD | 005.7565 PAL (Browse shelf(Opens below)) | CD 522 | 1 | Available | 126304 |
Includes CD-ROM.
Includes bibliographical references and index.
1.Understanding relational databases -- 2.Building the database with the data -- 3.The data control and data manipulation langagues and the data dictionary -- 4.Retrieving database records using SQL: the select where, and order by clauses -- 5.Retrieving records using SQL: the from, group by, and having clauses -- 6.Creating new valuse with character -- 7.Creating new values with numeric and date functions -- 8.Using set operators, subqueries and variables -- 9.Analytical processing with SQL -- 10.Using database and materialized views -- 11.Using SQL*Plus as a report-writing tool -- 12.What you can do if your SQL does not perform -- 13.Using business objects -- 14.The basics of PL/SQL -- 15.Handling exceptions and using name procedures -- 16.Advanced PL/SQL topics.
This comprehensive sourcebook of solutions and techniques for improving the use of Oracle SQL and PL/SQL covers performance tuning and troubleshooting, using Java with PL/SQL, and using Oracle's analytic functions to create special business information.