Beginning PL-SQL - From Novice to Pro by Donald Bales

By Donald Bales

Start with PL/SQL, the integrated language that each Oracle developer and database administrator needs to be aware of, in starting PL/SQL, a fast moving and example-filled educational. study from writer Don Bales wide event to find the main frequent facets of PL/SQL with out losing time with vague and out of date features.
Author Don Bales takes his 20+ years of expertise and a wealth of data he is accrued on PL/SQL utilization over these years and applies the 80/20 rule &emdash; disguise whats so much wanted and utilized by PL/SQL pros and steer clear of whats no longer important! the result's a publication that covers the entire key good points of PL/SQL with no squandering precious time discussing esoteric and out of date elements of the language. research what relatively concerns, that you should get to paintings feeling convinced with what you recognize approximately PL/SQL.
- become aware of the 20% of PL/SQL that offers you eighty% of the bangkey themes coated contain variables and datatypes, executing statements, operating with cursors, real-world items, debugging, checking out, and more.
- how you can write production-level, object-oriented PL/SQLyoull discover relational PL/SQL, yet not like such a lot different books at the topic, Don Bales emphasizes using PL/SQLs object-oriented good points as well.
- paintings via actual examples of utilizing of PL/SQLyoull study PL/SQL via employing it to real-world enterprise difficulties, no longer by means of heavy theory.
What youll learn
- How vital SQL is in PL/SQL
- tips on how to use PL/SQL in either a relational and object-relational setting
- the best way to create maintainable, modular, and reusable PL/SQL software units
- the significance of checking out as you pass, and of creating an enduring attempt plan for every module
- the significance of creating debugging features into your code and development an everlasting debug facility for every module
- the significance of documenting as you move, and within the procedure development an everlasting documentation set to your reusable modules
- how you can observe modular PL/SQL to unravel real-world problems
Who is that this ebook for?
Anyone who desires to create kept techniques opposed to an Oracle database utilizing PL/SQL. Programmers constructing functions to be deployed opposed to an Oracle database will want PL/SQL to take complete benefit of the facility Oracle has to provide. Database directors who desire to enforce performance uncovered simply through PL/SQL package deal interfaces also will locate this booklet useful.
About the Apress starting Series
The starting sequence from Apress is the correct option to get the data you want to land that the most important entry-level task. those books will educate you a regular and critical know-how from the floor up simply because they're explicitly designed to take you from "novice to professional." Youll begin your trip via seeing what you want to knowbut with no pointless concept and filler. Youll construct your ability set through studying find out how to prepare real-world initiatives step-by-step. So even if your target is your subsequent occupation problem or a brand new studying chance, the start sequence from Apress will take you thereit is your depended on consultant via unusual territory!

Show description

Read or Download Beginning PL-SQL - From Novice to Pro PDF

Best education books

Linux For Dummies, 6th Edition

Prior variations of Linux For Dummies have garnered rave reports. notwithstanding, there’s one frightening time period utilized to them—outdated! The sixth variation treatments that with easy-to-understand details at the newest model of the preferred Linux distributions, together with Fedora center, SuSE, Mandrake, Xandros, Linspire, and Knoppix.

Text and Artifact in the Religions of Mediterranean Antiquity: Essays in Honour of Peter Richardson (Studies in Christianity and Judaism, ESCJ 9)

Can archaeological is still be made to “speak” whilst introduced into conjunction with texts? Can written continues to be, on stone or papyrus, make clear the parables of Jesus, or at the Jewish view of afterlife? What are the bounds to using artifactual facts, and whilst is the worth overstated? textual content and Artifact addresses the advanced and exciting factor of the way basic spiritual texts from the traditional Mediterranean global are illuminated by way of, and in flip remove darkness from, the ever-increasing quantity of artifactual facts to be had from the encircling international.

Women and Terrorism: Female Activity in Domestic and International Terror Groups (Comtemporary Terrorism Studies)

This publication examines the connection among girls and terrorist actions within the post-World warfare II period. using comparative study into 26 terrorist firms world-wide, the paintings identifies a dichotomy wherein ladies are considerably extra energetic in household terrorist businesses than in foreign teams.

Choosing Students: Higher Education Admissions Tools for the 21st Century

This quantity brings numerous views to endure at the factor of ways larger schooling associations can - or should still - select scholars throughout the early a part of the twenty first century. some of the participants file on learn to increase and validate capability instruments to help these answerable for admission judgements.

Additional resources for Beginning PL-SQL - From Novice to Pro

Example text

Listing 1-22 is a query for selecting all the author names from the author table. There’s no WHERE clause to constrain which rows we will see. Listing 1-22. sql 1 2 3 SELECT name FROM author ORDER BY name; NAME ------------------CHRIS J DATE EDGAR F CODD HUGH DARWEN Listing 1-22 actually shows the query (SELECT statement) executed in SQL*Plus, along with the database’s response. The syntax of the SELECT statement in Listing 1-22 is as follows: SELECT , , FROM [ORDER BY ] where is one of the columns in the table listed, is the table to query, and is one or more columns by which to sort the results.

They can pull data values from other tables, for each column, or for multiple columns using subqueries. Let’s look at the use of subqueries. Update and Subqueries One of the biggest mistakes PL/SQL programmers make is to write a PL/SQL program to update selected values in one table with selected values from another table. Why is this a big mistake? Because you don’t need PL/SQL to do it. And, in fact, if you use PL/SQL, it will be slower than just doing it in SQL! We haven’t yet had an opportunity to work with any complex data, nor have we talked much about the SQL SELECT statement, so I won’t show you an example yet.

Listing 1-23. sql 1 2 3 4 SELECT name FROM author WHERE birth_date < to_date('19400101', 'YYYYMMDD') ORDER BY name; NAME -------------------------------------------------------EDGAR F CODD So while this is all very nice, we’ve only started to scratch the surface of the SELECT statement’s capabilities. Next, let’s look at querying more than one table at a time. Joins Do you remember that way back in the beginning of this chapter we went through the mental exercise of matching the value of the id column in the author table against the same column in the publication table in order to find out which publications were written by each author?

Download PDF sample

Rated 4.64 of 5 – based on 38 votes