By Donald Bales
Starting Oracle PL/SQL will get you begun in utilizing the integrated language that each Oracle developer and database administrator needs to recognize. Oracle Database is brim-full of integrated software good points which are unfastened for the utilizing, and PL/SQL is your price tag to studying approximately and utilizing these positive factors out of your personal code. With it, you could centralize company common sense within the database, you could offload program common sense, and you'll automate database- and application-administration projects. writer Don Bales offers in starting Oracle PL/SQL a fast moving and example-filled instructional. study from Don's large event to find the main normal points of PL/SQL, with no losing time on vague and out of date gains.
Read Online or Download Beginning Oracle PL/SQL, 2nd Edition PDF
Best oracle books
Particular variation utilizing Oracle purposes is designed to be the main entire computer reference on hand. It comprises precise renowned subject matters akin to production and HR/Payroll purposes. Implementation innovations and subject matters are coated for swift, pre-configured, phased, gigantic bang, reengineered and customised implementation tasks.
Construct powerful, feature-rich net functions utilizing Oracle APEX and Ext JS. upload extra subtle elements and performance to an Oracle APEX software utilizing Ext JS. construct your individual issues in response to Ext JS into APEX - constructing templates for areas, labels, and lists. Create plug-ins on your program workspace to augment the prevailing integrated performance of your APEX functions.
Grasp Oracle Database 12c PL/SQL program improvement increase, debug, and administer powerful database courses. jam-packed with precise examples and professional ideas from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains tips to retrieve and procedure info, write PL/SQL statements, execute powerful queries, contain Hypertext Preprocessor and Java, and paintings with dynamic SQL.
- Pro Oracle Application Express 4 (Expert's Voice in Databases)
- Oracle Database 10g Performance Tuning Tips & Techniques
- Oracle Performance Survival Guide: A Systematic Approach to Database Optimization
- Oracle SQL: Jumpstart with Examples
- Oracle Essentials - Oracle Database 11g
Extra info for Beginning Oracle PL/SQL, 2nd Edition
Exceptions Exceptions allow you to catch errors as your PL/SQL program executes, so you have control over what happens in response to those errors. PL/SQL predefines more than 20 named exceptions, but you’ll probably use only a few. ■■Note After you’ve gained more PL/SQL experience, you may even want to define your own named exceptions. For more information about custom exceptions, see Oracle’s PL/SQL User’s Guide and Reference. info Chapter 2 ■ Blocks, Functions, and Procedures Common Exceptions As you’ll learn in future chapters, there are a handful of commonly seen exceptions.
You can see my solutions to these scripts in the book’s source code directory for Chapter 1. Now let’s move on to creating content tables. Create a Content Table This time, let’s create some content tables. I’ll write the first two scripts, and then you do the rest. Listing 1-28 is a script to create the WORKERS table. Listing 1-28. tab rem by Donald J. gather_table_stats(USER, 'WORKERS'); Looks familiar, doesn’t it? It looks a lot like the code table scripts you created earlier. The exceptions are lines 43 through 46 and 48 through 51, where I’ve added DDL to create two foreign key constraints.
Info Chapter 2 ■ Blocks, Functions, and Procedures Anonymous Block Example Listing 2-1 is an example of an anonymous PL/SQL block. Comments describe the different sections. Listing 2-1. sql 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 -- This is an anonymous procedure, so it has no name DECLARE /* You declare local cursors, variables, and methods here, but you don't need to have a declaration section. */ BEGIN -- You write your executable code here NULL; -- Ahhh, you've got to have at least one command!