Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c, 6th Edition

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c, 6th Edition

AUTHOR: Steven Feuerstein; Bill Pribyl

PUBLISHER: O'Reilly Media

PAGES: 1392

ISBN-10: 9781449324452; ISBN-13: 978-1449324452

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.

Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.

* Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
* Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
* Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
* Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
* Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers

About the Author
Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). He has also published his first book for kids: http://stevenfeuerstein.com/vivianvultur?e. Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and served as PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Steven's latest initiative is the PL/SQL Challenge (http://www.plsqlchallenge.com), a daily quiz for PL/SQL developers; hundreds of programmers play each day. Check it out and join the fun! Steven's online technical cyberhome is located at www.ToadWorld.com/SF. You can also catch up on his latest, mostly non-PLSQL rants at http://feuerthoughts.blogspot.com.

Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church. Visit Bill's firm at http://www.datacraft.com.

Book Category

Android Developer / Asp.Net / Asp.Net MVC / Blockchain / C# / C++ / Computer Science / Database / Game Developer / Java / JavaScript / jQuery / Linux / Maven / MS Sql / MySQL / Networking / Oracle / PHP / Python / Spring / VB.Net / Visual Studio / Web Developer

HRMS & Payroll Web Application

Employee Self-Service Online Filing Form

Delegate work to your employees and get more productive right away with a smart self-service dashboard user account for every employee. Modern HR management tools can help you remove the daily routine task that the system can handle it automatically and easy. read more »

Broken Time Schedule Data Entry and Approval Form

Broken time schedule is not suitable on automating work distribution need module data entry to handle the accurate computation that system get the computed hours during the timesheet processing. The logic of computation is time difference for every time in/out entry that excess of regular 8 hours is overtime work. The approver decide if the overtime work is required to deduct 1 hour OT hour lunch break or OTND lunch break before it approve. read more »

BIR Alphalist .Dat File Conversion to ITR Form 2316

Easy way to convert your annual BIR .dat file output to BIR Form 2316 in a single file pdf format using this web based application tools and also easiest way of printing because it contain a one file only. read more »

Inventory Management Web Application

Inventory Management Web Application is a software that can track inventory of products, orders, suppliers, customers, sales and deliveries in any device with internet browser. Widely used in a variety of business industries, from manufacturing to utilities, healthcare, education, schools, government, and more. read more »

Data Entry of Taxable and Non-Taxable with Previous Employer

Generating annual report of BIR Alphalist contains a history of employee with previous tax deduction to consolidate it for yearly tax computation. Pinoy Web Application have a tools to input employee newly hired with previous employer within the year that covered of annual tax report that system automatic get the additional information during the processing of a year end alphalist tax schedule 7.1, 7.2, 7.3, 7.4 & 7.5. read more »