gogo
Amazon cover image
Image from Amazon.com

Oracle SQL and Pl/SQL handbook : a guide for data administrators, developers, and business analysts / John Adolph Palinski.

By: Material type: TextTextPublication details: Boston, [Mass.] ; London : Addison-Wesley, 2002.Description: 432 p. ; 24 cmISBN:
  • 9780201752946 (pbk.) :
  • 0201752948 (alk. paper)
Subject(s): DDC classification:
  • 005.7565 PAL
LOC classification:
  • QA76.73.S67
Contents:
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.
Summary: 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.
Holdings
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.

Powered by Koha