By Donald Bales
Beginning Oracle PL/SQL will get you began in utilizing the integrated language that each Oracle developer and database administrator needs to comprehend. Oracle Database is brim-full of integrated software positive factors which are unfastened for the utilizing, and PL/SQL is your price ticket to studying approximately and utilizing these good points out of your personal code. With it, you could centralize enterprise common sense within the database, you could offload program good judgment, and you'll automate database- and application-administration projects.
Author Don Bales offers in Beginning Oracle PL/SQL a fast moving and example-filled educational. research from Don’s large event to find the main favourite elements of PL/SQL, with no losing time on imprecise and out of date good points.
The writer takes his 20+ years of expertise and a wealth of facts he is amassed on PL/SQL utilization over these years and applies the 80/20 rule: conceal what is so much wanted and utilized by PL/SQL execs and steer clear of what is now not valuable! the result's a publication that covers all of the key good points of PL/SQL with out wasting precious time discussing esoteric and out of date elements of the language. study what quite concerns, that you can get to paintings feeling convinced with what you recognize approximately PL/SQL.
- Covers the main issues that topic, together with variables and datatypes, executing statements, operating with cursors, bulk operations, real-world gadgets, debugging, trying out, and more.
- Teaches you to write down production-level, object-oriented PL/SQL. you will discover relational PL/SQL, yet in contrast to so much different books at the topic, this one emphasizes using PL/SQLs object-oriented positive aspects as well.
- Guides you in operating via genuine examples of utilizing of PL/SQL. you will examine PL/SQL by means of utilizing it to real-world enterprise difficulties, no longer through heavy theory.
Read or Download Beginning Oracle PL/SQL PDF
Best oracle books
Layout Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL purposes with specialist counsel from an Oracle programming specialist. With complete assurance of the most recent good points and instruments, Oracle Database 11g PL/SQL Programming lays out every one subject along certain reasons, cut-and-paste syntax examples, and real-world case stories.
This booklet is written in an easy-to-read type, with a powerful emphasis on real-world, functional examples. step by step factors are supplied for acting very important management projects. when you are an internet server administrator trying to find a brief consultant for appearing regimen and demanding WebLogic server management features, together with configuring WebLogic server and deploying Java EE purposes, then it is a excellent booklet for you.
The Definitive advisor to Oracle Database 11gGet complete information at the robust positive aspects of Oracle Database 11g from this completely up to date Oracle Press consultant. Oracle Database 11g: the full Reference explains how one can use all of the new good points and instruments, execute robust SQL queries, build PL/SQL and SQL*Plus statements, and paintings with huge items and object-relational databases.
- Oracle 11i E-Business Suite from the Front Lines
- Pro ODP.NET for Oracle Database 11g (Expert's Voice in Oracle)
- Pro Oracle Spatial, 1st Edition
- Oracle SQL Tuning with Oracle SQLTXPLAIN
Additional info for Beginning Oracle PL/SQL
In order to selectively update, you need to specify a WHERE clause in your UPDATE statement. Let’s first take a look at an UPDATE statement without a WHERE clause. Fix a Mistake with Update As I alluded to earlier, I forgot to make the text values in the database all in uppercase. Listing 1-18 is my solution to this problem for the authors table. Listing 1-18. upd 1 2 3 4 18 UPDATE authors SET name = upper(name); COMMIT; Chapter 1 ■ Relational SQL The syntax used by Listing 1-18 is as follows: UPDATE
Write the DML script without a COMMIT statement. 2. del extension. 3. Execute your script in SQL*Plus. Darwen should no longer be in the database. Listing 1-21 shows how I got rid of him. Listing 1-21. del 1 2 DELETE FROM authors WHERE id = 300; Oops, no more Darwen. I changed my mind. Let’s fix that quickly! Type ROLLBACK; at your SQL*Plus prompt and then press the Enter key. The transaction—everything you did from the last time you executed a COMMIT or ROLLBACK statement—has been rolled back.
BEGIN: Every PL/SQL block has an executable section. It starts with the keyword BEGIN. BEGIN marks the beginning of where you put your program logic. And every PL/SQL program must have at least one line of executable code, even if it’s the keyword NULL, which in this context means no operation. • EXCEPTION: Every PL/SQL block has an exception-handling section. It starts with the keyword EXCEPTION. This is where you will catch any database or PL/SQL errors, or as they are affectionately known, exceptions.