bokomslag Oracle Database 10g PL/SQL 101
Data & IT

Oracle Database 10g PL/SQL 101

Christopher Allen

Pocket

649:-

Funktionen begränsas av dina webbläsarinställningar (t.ex. privat läge).

Uppskattad leveranstid 5-10 arbetsdagar

Fri frakt för medlemmar vid köp för minst 249:-

  • 416 sidor
  • 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. youll 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
  • Författare: Christopher Allen
  • Illustratör: 100 illus
  • Format: Pocket/Paperback
  • ISBN: 9780072255409
  • Språk: Engelska
  • Antal sidor: 416
  • Utgivningsdatum: 2004-09-01
  • Förlag: McGraw Hill