By Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox
Do you wish extra from a PL/SQL booklet than simply the right kind key terms and a few lovely syntax diagrams? have you ever been looking in useless for real-world examples and real thoughts for maximizing the advantages of PL/SQL inside of your company? you can find them right here in Mastering Oracle PL/SQL: sensible Solutions, the inaugural name of the pioneering OakTable Press sequence from Apress.
This is not an instructional on find out how to code PL/SQL. it is designed to teach you the way to code PL/SQL well. It exhibits you ways to write down code that may run speedy and wont holiday in high-load, multiuser environments. It covers the gigantic array of the performance that PL/SQL presents, together with potent dealing with of relational and summary info, safety, triggers, dynamic websites presentation from in the database, construction of a DBA toolkit, and potent debugging techniques.
This publication units out to redress the unjust feedback leveled at PL/SQL in years passed by. It promises the instruments and methods to make sure that, no matter what your wishes are, the PL/SQL you construct will run as successfully as attainable. the sensible ideas supplied during this publication might help you to gain the genuine energy and performance PL/SQL can provide your projects.
If you are brand-new to PL/SQL, then you should take a little time to get acquainted with the language ahead of tackling this ebook. it isn't for the entire newbie. yet as soon as youre up and working, you can find this booklet a useful advisor for making sure that the PL/SQL ideas you construct are powerful, practice good, and are effortless to maintain.
Read or Download Mastering Oracle PL/SQL: Practical Solutions PDF
Best oracle books
Oracle Database 11g New Features
FOREWORD by way of Tom Kyte Your Must-Have advisor to every thing New in Oracle Database 11gRealize the entire power of Oracle Database 11g with aid from the specialists. Written by way of Robert G. Freeman, and with insightful observation all through from Arup Nanda, this Oracle Press consultant bargains complete info at the architectural adjustments, database management improvements, availability and restoration revisions, safeguard improvements, and programming recommendations.
Oracle Database 10g, A Beginner's Guide
Presents starting DBAs and builders with a superior origin within the database management and programming fundamentals had to embark on an Oracle profession. the focal point is on Oracle Database 10g, yet you’ll get the basics appropriate to all Oracle database releases.
Pro Oracle Database 12c Administration
Seasoned Oracle Database 12c management is a publication serious about effects. writer Darl Kuhn attracts from a good of expertise over a decade deep to put out real-world ideas that result in luck as an Oracle Database administrator. He provides transparent causes on the way to practice severe initiatives. He weaves in conception the place useful with no bogging you down in unneeded aspect.
Oracle Application Express for Mobile Web Applications
Oracle software exhibit is celebrated within the Oracle neighborhood as a useful tool for growing internet purposes compatible for computing device browsers. positive aspects have now been further to open up the realm of cellular searching, bringing the simplicity and expressiveness of Appliction exhibit to endure in constructing functions to run with an almost-native feel and appear on structures akin to iOS, Android, and home windows telephone.
- Oracle 12c For Dummies
- Oracle Database 11g: New Features for DBAs and Developers
- Oracle Data Mining - Application Developer's Guide, 10g Release 2
- Expert one-on-one Oracle
- Oracle performance tuning for 10gR2
Extra resources for Mastering Oracle PL/SQL: Practical Solutions
Sample text
Performance-wise, there is no comparison. Comparing 50,000 executions of the home-grown BITAND PL/SQL function to its native counterpart using the SQL*Plus timing facility shows the dramatic difference. 28 Efficient PUSQL SQL> declare 2 x number; 3 begin for i in 1 .. 50000 loop 4 x:= binary_and(i,i+l); 5 end loop; 6 7 end; 8 I PL/SQL procedure successfully completed. 07 SQL> declare 2 x number; 3 begin 4 for i in 1 •• 50000 loop 5 x:= bitand(i,i+l); 6 end loop; 7 end; 8 I PL/SQL procedure successfully completed.
SQL> exec literals; PL/SQL procedure successfully completed. 68 SQL> alter session set sql_trace = false; Session altered. Without any further investigation, it's quite possible that a developer would be satisfied with this result. After all, we ran 10,000 queries in 30 seconds. When we run Tkprof2 on the raw trace data, the summary produces a startling result. 2. For details about how to use the tracing facilities and the trace formatter tool Tkprof, consult Chapter 10 of the Performance Tuning Guide and Reference in the standard Oracle documentation set.
That is a lot of work to do for every single SQL statement that gets passed to your program for checking. However, one simple enhancement could be to keep a log of SQL statements that have been processed at some stage in the past. If a SQL statement is presented for checking more than once, you need merely consult the log to see if it is valid. Of course, if every SQL statement from each application program were different, this log would be of little benefit. In fact, over time, your centralized log of SQL statements is probably going to get quite large-searching through it to see if an SQL statement is already present could in itself take a reasonable amount of CPU.