Beginning PL/SQL : from novice to professional by Donald Bales

By Donald Bales

Get began with PL/SQL, the integrated language that each Oracle developer and database administrator needs to be aware of, in Beginning PL/SQL, a fast moving and example-filled educational. study from writer Don Bales wide event to find the main widely used points of PL/SQL, with no losing time with imprecise and out of date good points.

Bales takes his 20+ years of expertise and a wealth of records he is accrued on PL/SQL utilization over these years and applies the 80/20 rule: conceal what is such a lot wanted and utilized by PL/SQL pros and keep away from what is no longer beneficial! the result's a booklet that covers the entire key beneficial properties of PL/SQL with out squandering precious time discussing esoteric and out of date components of the language. examine what particularly concerns, that you should get to paintings feeling convinced with what you recognize approximately PL/SQL.

  • Discover the 20% of PL/SQL that provides you eighty% of the bang! Key themes coated comprise variables and datatypes, executing statements, operating with cursors, real-world items, debugging, trying out, and more.
  • Learn tips on how to write production-level, object-oriented PL/SQL. You'll discover relational PL/SQL, yet not like so much different books at the topic, this one emphasizes using PL/SQLs object-oriented positive factors besides.
  • Work via genuine examples of utilizing of PL/SQL. You'll examine PL/SQL by way of making use of it to real-world company difficulties, now not through heavy theory.

What you’ll learn

  • How very important SQL is in PL/SQL
  • How to take advantage of PL/SQL in either a relational and object-relational atmosphere
  • How to create maintainable, modular, and reusable PL/SQL application devices
  • The value of trying out as you pass, and of establishing an enduring try plan for every module
  • The value of establishing debugging functions into your code and construction an enduring debug facility for every module
  • The significance of documenting as you pass, and within the strategy development an everlasting documentation set on your reusable modules
  • How to use modular PL/SQL to resolve real-world difficulties

Who this e-book is for

somebody who desires to how one can create kept strategies opposed to an Oracle database utilizing PL/SQL. Programmers constructing purposes to be deployed opposed to an Oracle database will want PL/SQL to take complete benefit of the ability Oracle has to provide. Database directors who desire to enforce performance uncovered in simple terms through PL/SQL package deal interfaces also will locate this booklet valuable.

Show description

Read Online or Download Beginning PL/SQL : from novice to professional PDF

Similar oracle books

Pro ODP .NET for Oracle Database 11g

This publication is a complete and easy-to-understand advisor for utilizing the Oracle information supplier (ODP) model 11g at the . internet Framework. It additionally outlines the center GoF (Gang of 4) layout styles and coding concepts hired to construct and set up high-impact mission-critical purposes utilizing complex Oracle database beneficial properties in the course of the ODP.

Oracle User Productivity Kit 3.5

This publication offers a realistic instructional on UPK's performance, with the purpose of educating builders find out how to most sensible leverage this performance to boost top quality education fabric. The e-book courses readers from the fundamentals of recording via to including price via web content applications (Infoblocks), position filters, Glossaries, and extra.

OCP: Oracle9i DBA Fundamentals II Study Guide

This is the publication you must organize for examination 1Z0-032: Oracle9i Database: basics II. In-depth insurance of reputable examination ambitions functional details on enforcing and coping with Oracle9i databases hundreds and hundreds of tough evaluate questions, within the publication and at the CD Authoritative assurance of all examination targets, together with: determining recommendations integrated with Oracle9i for coping with complicated networks utilizing Oracle web companies and buyer server connections setting up internet buyer connections via Oracle networking items Troubleshooting database connections utilizing and configuring the Oracle Shared Server Backing up, restoring, and recuperating databases Configuring the database archiving mode utilizing restoration supervisor (RMAN) Loading facts into, and transporting info among databases observe: CD-ROM/DVD and different supplementary fabrics will not be integrated as a part of publication dossier.

Oracle database 12c security

Most sensible Practices for entire Oracle Database safety Written via popular specialists from Oracle's nationwide safety team, Oracle Database 12c defense offers confirmed ideas for designing, enforcing, and certifying safe Oracle Database platforms in a multitenant structure. The ideas also are appropriate to standalone databases.

Extra info for Beginning PL/SQL : from novice to professional

Example text

So it’s always a good idea to specify which rows to update with an additional WHERE clause. For example, I could have added the following line: WHERE name <> upper(name) That would have limited the UPDATE to only those rows that are not already in uppercase. It’s Your Turn to Update I’ve fixed my uppercase mistake in the author table. Now you can do the same for the publication table. So please update the publication titles to uppercase. 1. Write the DML script. 2. upd extension. 3. Execute your script in SQL*Plus.

It’s a kind of the chicken vs. ) Instead, let’s create a unique index on the name, birth_date, and gender columns of the author table. Listing 1-3 shows our example. Listing 1-3. ndx. 1 2 3 4 5 CREATE UNIQUE INDEX author_uk1 on author ( name, birth_date, gender ); The syntax for the CREATE INDEX statement is as follows: CREATE [UNIQUE] INDEX on ( , , ); where is the name of the index, is the name of the table, and is the name of a column.

Listing 1-11 shows the DDL to create a view that contains the required SQL SELECT statement. Listing 1-11. id; The syntax for the CREATE VIEW statement used in Listing 1-11 is as follows: CREATE [OR REPLACE] VIEW AS ; where is the name of the view (the name that will be used in other SQL statements as though it’s a table name), and is a SQL SELECT statement against one or more tables in the database. Once again, the brackets around the OR REPLACE clause denote that it is optional.

Download PDF sample

Rated 4.26 of 5 – based on 47 votes