Learning Oracle PL/SQL

著者

書誌事項

Learning Oracle PL/SQL

Bill Pribyl with Steven Feuerstein

O'Reilly, 2001

大学図書館所蔵 件 / 全1件

この図書・雑誌をさがす

注記

On cover: Covers Oracle9i

"Oracle development languages"-- Cover

Includes index

内容説明・目次

内容説明

Oracle development tools come and go, but one of the few constants in the Oracle database environment is the PL/SQL programming language, which has been around for more than a decade. As Oracle's premier tool for building store procedures, PL/SQL supplements the standard database language, SQL, with the features needed to build real-world applications. This volume is suitable for newcomers to the language. It begins with a discussion of what PL/SQL is and what it's good for, and then presents language features, one at a time. A consistent and understandable example - the development of a library's electronic catalogue system - runs through the chapters.

目次

  • Part 1 PL/SQL - what, when and where: what is PL/SQL?
  • why use PL/SQL?
  • what you need to get started with PL/SQL. Part 2 Fundamentals: PL/lingo
  • running your first PL/SQL program
  • introduction to program structure
  • variables
  • common operators
  • conditional logic
  • executing in circles - loop statements
  • code formatting - requirements and guidelines
  • some advanced fundamentals. Part 3 Let's code!: some backrgound on the example
  • a first programming exercise
  • retrieving a book count with a function
  • make your code resilient
  • using PL/SQL packages to organize code
  • going to the next level
  • now what?. Part 4 Go web, young man: introduction to HTML
  • using PL/SQL to create web pages
  • what else?. Part 5 Fetch!: what's the big deal?
  • a simple-minded approach to retrieving one row
  • retrieving more than one row using a cursor
  • presenting query results via a web page
  • building a web-based search page using dynamic SQL
  • advanced data retrieval topics. Part 6 Keeping house: organize your code
  • use tools to write code effectively. Part 7 Security - keep the bad guys out: Oracle security primer
  • organizing accounts to improve security
  • analyzing the library system's requirements
  • keeping a trail of database changes
  • special security topics for PL/SQL developers. Part 8 Communicating with the outside world: sending Internet e-mail from PL/SQL
  • using the mail sender in the library system
  • receiving e-mail inside the database
  • fetching data from a remote web site
  • integration with other languages. Part 9 Intermediate topics and other diversions: riding the software lifecycle
  • lists o' stuff (collections) in PL/SQL
  • exception-handling packages
  • transaction control
  • the PL/SQL compiler
  • managing patron and librarian privileges
  • still more PL/SQL features. Part 10 "Making good" of database programming: the evidence
  • the problem
  • answering the objections
  • what to do.

「Nielsen BookData」 より

詳細情報

ページトップへ