Гэвин Пауэлл

Oracle 9i: SQL Exam Cram 2 (+ CD-ROM)

Скачать

Гэвин Пауэлл
   - Oracle 9i: SQL Exam Cram 2 (+ CD-ROM)

In This Book You'll Learn How To:

  • Retrieve data using the select statement.
  • Filter rows with the where clause.
  • Sort data with the order by clause.
  • Use operators, conditions, pseudo columns expressions, and single row functions.
  • Group and summarize rows with the group by clause.
  • Construct sub queries and other specialized queries.
  • Format with SQL*Plus.
  • Change data using DML insert, update, and delete commands.
  • Use DDL commands for creating and maintaining tables, their data types, and constraints.
  • Use DDL commands for creating and maintaining views, indexes, sequences, and synonyms.
  • Implement Oracle database security.