Cantitate/Preț
Produs

Oracle Database 10g PL/SQL 101

Autor Christopher Allen
en Limba Engleză Paperback – 16 sep 2004
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Get The Ins-and-Outs of SQL and PL/SQL From an Oracle Expert
Perform database functions quickly and easily using the comprehensive information in this step-by-step guide. Oracle professional Christopher Allen begins with database basics and progresses to plain-language explanations and real-world examples of SQL statements and PL/SQL programs. You’ll learn how to manage, query, and manipulate data, use SQL*Plus, create SQL functions, and write practical PL/SQL applications. Review questions, chapter summaries, and hands-on projects will have you understanding and exploiting the powerful features of Oracle Database 10g in no time.
  • Create tables, rows, records, columns, and fields
  • Store text, numbers, dates, pictures, and soundfiles in tables and columns
  • Define, manipulate, retrieve, and delete data, using SQL commands
  • Select, sort, and filter records with SQL functions and procedures
  • Write SQL commands to declare variables using anchored types
  • Use SAVEPOINT and ROLLBACK commands to ensure multilevel undo
  • Perform time-based and hierarchical data queries
  • Edit and reuse commands in script files, using the SQL*Plus program
  • Use PL/SQL views, sequences, procedures, functions, and packages
  • Use triggers to automate auditing, security, and maintenance tasks
Citește tot Restrânge

Preț: 21812 lei

Preț vechi: 27264 lei
-20% Nou

Puncte Express: 327

Preț estimativ în valută:
4175 4404$ 3479£

Carte disponibilă

Livrare economică 12-26 decembrie

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9780072255409
ISBN-10: 0072255404
Pagini: 416
Dimensiuni: 185 x 229 x 22 mm
Greutate: 0.7 kg
Editura: McGraw Hill Education
Colecția McGraw-Hill
Locul publicării:United States

Cuprins

PART I Database Basics

1 Introduction to Databases

2 Storing and Retrieving Data: The Basics

3 Advanced Data Manipulation

4 Controlling SQL*Plus

PART II Advanced SQL

5 SQL Functions

6 Using Indexes and Constraints

7 Other Useful Oracle Techniques

PART III Create Programs Using PL/SQL

8 Introduction to PL/SQL

9 More PL/SQL ToolsGlossary of Common Oracle Terms