Beginning PL/SQL: From Novice to Professional

Capa
Apress, 18 de out. de 2007 - 476 páginas

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time with obscure and obsolete features.

Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule: cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

  • Discover the 20% of PL/SQL that gives you 80% of the bang! Key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
  • Learn how to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well.
  • Work through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.
 

Páginas selecionadas

Conteúdo

Genesis
1
CHAPTER
2
CHAPTER
3
CHAPTER
5
Constraints
7
CHAPTER
8
Update
19
Select
22
ObjectTypes
170
ObjectViews
184
Summary
209
After the Fact
217
One Step at a Time
243
Profiling
251
Hey Dont Forget SQL
262
Testing
307

PLSQL Is Square Man
39
Procedures
47
Packages
54
Scope
74
Updates
115
Summary
126
Bulk Collect
148
Just Like It Is in the Real World
163
What Does This Thing Do Anyway?
347
Distributable Documentation
360
Summary
367
Fairy Tales
369
Divide and Conquer
395
Summary
428
INDEX
451
Direitos autorais

Outras edições - Ver todos

Beginning PL/SQL: From Novice to Professional
Donald Bales
Prévia não disponível - 2007
Beginning Pl/Sql: From Novice To Professional
Donald J. Bales
Prévia não disponível - 2007
Beginning PL/SQL: From Novice to Professional
Donald Bales
Prévia não disponível - 2008

Termos e frases comuns

alter anonymous PL/SQL application assignment author table Bales begin behavior birth_date called chapter clause code table COLLECT column COMMIT CONSTRUCTOR create cursor data type database DEBUG DEBUG_OTS declare DELETE Donald element entry error example exception execute exists Figure filename follows function gender_id get_id going initial INSERT Inside key constraint keyword Listing look loop means method n_id NULL object Oracle package body parameters passed performance PL/SQL block PL/SQL procedure PL/SQL program PL/SQL table primary key procedure program unit publication table query raise record relational result Save scope script SELECT statement sequence shows sleep solution specified SQL statement SQL*Plus SQLERRM STATIC stored syntax table_name test unit there’s Turn unique UPDATE USERS varchar2 variable worker WORKER_T WORKER_TYPE_T write

Sobre o autor (2007)

Donald Bales is a computer applications consultant specializing in the analysis, design, and programming of client-server and web-based distributed systems, systems integration, and data warehousing. Don has over 20 years of experience with Oracle as both a developer and a database administrator, and 10 years of experience with Java. He is currently working on the migration of medical and industrial hygiene systems to a web environment for a major oil company. When he is not developing applications, Donald can often be found working with horses, playing the piano, or playing the bagpipes. Donald has had several careers, and has at various times been a mechanic, a general contractor, Mr. Mom, a developer, and currently a consultant. He has a bachelor of science degree in business from Elmhurst College in Illinois. Don resides in Downers Grove, Illinois, with his wife, Diane, and his daughter, Kristyn. He can be contacted by e-mail at don@donaldbales.com.

Informações bibliográficas

TítuloBeginning PL/SQL: From Novice to Professional
Expert's Voice in Oracle
AutorDonald Bales
Ediçãoilustrada
EditoraApress, 2007
ISBN1430204206, 9781430204206
Num. págs.476 páginas
  
Exportar citaçãoBiBTeX EndNote RefMan