Author : Steven Feuerstein
Publisher : "O'Reilly Media, Inc."
Page : 1028 pages
File Size : 26,68 MB
Release : 2002
Category : Computers
ISBN : 9780596003814
The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.
Author : Steven Feuerstein
Publisher : "O'Reilly Media, Inc."
Page : 207 pages
File Size : 23,48 MB
Release : 2001-04-09
Category : Computers
ISBN : 1449378765
In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time.Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code: How should I format my code? What naming conventions, if any, should I use? How can I write my packages so they can be more easily maintained? What is the most efficient way to query information from the database? How can I get all the developers on my team to handle errors the same way? The book contains 120 best practices, divided by topic area. It's full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O'Reilly web site.Oracle PL/SQL Best Practices is intended as a companion to O'Reilly's larger Oracle PL/SQL books. It's a compact, readable reference that you'll turn to again and again--a book that no serious developer can afford to be without.
Author : Djoni Darmawikarta
Publisher :
Page : 0 pages
File Size : 12,39 MB
Release : 2014
Category : Database management
ISBN :
Author : Michael McLaughlin
Publisher : McGraw Hill Professional
Page : 1194 pages
File Size : 38,12 MB
Release : 2014-02-07
Category : Computers
ISBN : 007181244X
Master Oracle Database 12c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries
Author : Steven Feuerstein
Publisher : O'Reilly Media
Page : 178 pages
File Size : 42,58 MB
Release : 2007-11-26
Category : Computers
ISBN : 9780596514044
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Calling PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.
Author : Susan Boardman
Publisher : Prentice Hall Professional
Page : 774 pages
File Size : 22,50 MB
Release : 2003
Category : Computers
ISBN : 9780130477316
Learn to use Oracle 9i to build dynamic, data-driven Web sites. Get step-by-step details on creating and deploying Web applications using PL/SQL, HTML, Java, XML, WML, Peri and PHP. This book covers everything users need to know to master Web application development in an Oracle environment - using PL/SQL.
Author : Steven Feuerstein
Publisher : "O'Reilly Media, Inc."
Page : 189 pages
File Size : 43,69 MB
Release : 2015-09-09
Category : Computers
ISBN : 1491919981
Annotation This pocket reference condenses the most vital information from Oracle PL/SQL programming into an accessible quick reference that summarises the basics of PL/SQL - block structure, fundamental language elements, data structures, control statements, and use of procedures, functions and packages.
Author : Saurabh K. Gupta
Publisher : Packt Publishing Ltd
Page : 647 pages
File Size : 50,67 MB
Release : 2012-01-01
Category : Computers
ISBN : 1849687234
This book is packed with real world examples that cover all the advanced features of PL/SQL. In turn, each major certification topic is covered in a separate chapter that makes understanding concepts easier. At the end of each chapter, you will find plenty of practice questions to strengthen and test your learning.If you are a PL/SQL developer looking for deeper insight and a move from mid-level programmer to professional database developer, then this is the best guide for you. This book is also an ideal guide for all the Associate level PL/SQL programmers who are preparing for the Professional 1Z0-146 certification. This book assumes you have prior knowledge of PL/SQL programming.
Author : Djoni Darmawikarta
Publisher : CreateSpace
Page : 130 pages
File Size : 27,30 MB
Release : 2014-04-16
Category : Computers
ISBN : 9781497575837
PL/SQL is the Oracle Procedural Language extension of SQL. PL/SQL is integrated within the Oracle database. A PL/SQL program can have both SQL statements and procedural statements. In the program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow, by applying, for example, the PL/SQL's if-then-else and looping structures. This book, Oracle PL/SQL Programming Fundamentals By Examples, is for PL/SQL beginners. If you have no prior or limited skill of PL/SQL, and you want to learn the Oracle PL/SQL programming language the practical way, then this book is perfect for you. When you finish reading the book and trying its examples, you would have equipped yourself with PL/SQL fundamental skills to start writing some PL/SQL programs for a real-world development project. Source codes listing of the examples are included in the Appendix of the book.
Author : Dan Hotka
Publisher :
Page : pages
File Size : 30,30 MB
Release : 2015
Category :
ISBN :
"In the fundamentals module, Oracle ACE Director Dan Hotka teaches developers how to work with existing code and create new programs. Along the way, students will learn both conditional and looping syntax and techniques, error handling and error processing, plus how to work with script files, procedures, functions and packages (a collection of procedures and functions). In the advanced module, Dan demonstrations how to take advantage of better options for performance, gain knowledge about the newer features of the language, as well as actually work with these same features in hands-on lab exercises. The students will learn the latest features of PL/SQL collections, triggers, and a variety of compiler features such as conditional compilation, result_cache/deterministic features for functions, autonomous transactions, optimizing compiler features, and more. Dan covers additional exception processing useful for collections. The advanced lessons include useful extensions to the error processing part with a clever use of database triggers. This advanced lessons also covers a variety of PL/SQL performance tips and the tuning and debugging tools for the PL/SQL programming environment. This LiveLessons course contains hands-on lab exercises throughout, and three common tools are used for demonstration, including SQL*Plus, Toad, and SQL*Developer. Students can use the Oracle PL/SQL development tool of their choice to do the hands-on labs with these lessons. All examples work with Oracle10, Oracle11, and Oracle12 databases, but the concepts and most of the tips apply to any Oracle database."--Resource description page.
