Configuration
Collapse menu
Fixed sidebar
Top navbar
Top navbar v.2
*Primary layout
Boxed layout
Fixed footer
Skins
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

LATEST BLOG POST

HRIS: Payroll Process

The payroll process involves calculating and disbursing employee salaries, wages, and benefits on a regular basis. Stay updated with employment laws, tax regulations, and other relevant compliance requirements to ensure accurate payroll processing and avoid penalties or legal issues.

HRIS: Timekeeping Process

Implementing an effective timekeeping process helps ensure accurate payroll calculations, compliance with labor laws, and fair compensation for employees' work hours. It also provides valuable data for analyzing workforce productivity and resource allocation.

HRIS: Recruitment and Training

Recruitment and training should be ongoing processes to attract and retain top talent and ensure the team is equipped with the necessary skills and knowledge to meet organizational goals.

HRIS: Human Resources

Human resources (HR) is a crucial department within an organization that focuses on managing and developing the people who work for the company. The HR department is responsible for various functions related to employee recruitment, hiring, training, performance management, benefits administration, and employee relations.

Understanding the Basics of Payroll Processing

Payroll processing is the administrative task of calculating and distributing employee salaries and benefits. It involves several steps, including collecting and verifying employee time and attendance data, calculating wages and deductions, and generating paychecks or direct deposits.

DTR Timekeeping Tips: Do's and Don'ts

Employers must keep accurate records of non-exempt employees work hours to comply state and local laws. This straightforward process can become complex when employees start work early or leave late, travel for business, participate in company trainings, and use mobile devices to remain connected to work after-hours.

Employee Timekeeping: Tool to Improve Efficiency and Accuracy

Overall, implementing a reliable timekeeping tool can significantly improve efficiency and accuracy in employee time tracking. It streamlines processes, reduces errors, ensures compliance, and provides valuable data for decision-making.

Automate Loans Deduction using Payroll Setup

By following these steps, you can automate loan deductions using payroll setup, saving time and ensuring accuracy in loan repayments for your employees.

Transforming HR into Digital Through Technology

By embracing technology and digitizing HR processes, organizations can streamline operations, improve employee experience, and enable HR professionals to focus on strategic initiatives that drive business success.

Timekeeping and Attendance Setup

Specific setup and configuration of your timekeeping and attendance system will depend on the unique needs and requirements of your organization. It's important to adapt these steps to fit your specific circumstances and consult with HR professionals or software providers for guidance.

Free Online Tools

Related Programming Books

Disclaimer

Programming books display here are property of respective owners. All information about the book published in this website is in good faith and for general information purpose only.

Please support author by buying hardcopy to the nearest book store in your place or order books in publisher websites.