Oracle PL/SQL Language Pocket Reference

Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 1491919965
Category : Computers
Languages : en
Pages : 145

Book Description
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c. Whether you’re a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of: Fundamental language elements, such as block structure, datatypes, and declarations Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Execution of PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration This handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming.

Oracle PL/SQL Language Pocket Reference

Author: Steven Feuerstein
Publisher: O'Reilly Media
ISBN: 9780596514044
Category : Computers
Languages : en
Pages : 178

Book Description
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.

Oracle PL/SQL Best Practices

Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 1449378765
Category : Computers
Languages : en
Pages : 207

Book Description
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.

Oracle PL/SQL Programming

Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596003814
Category : Computers
Languages : en
Pages : 1028

Book Description
The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.

Oracle PL / SQL For Dummies

Author: Michael Rosenblum
Publisher: John Wiley & Sons
ISBN: 0764599577
Category : Computers
Languages : en
Pages : 443

Book Description
Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more. Discover how to Write efficient, easy-to-maintain code Test and debug PL/SQL routines Integrate SQL and PL/SQL Apply PL/SQL best practices Use new features introduced in Oracle 9i and 10g

LINQ Pocket Reference

Author: Joseph Albahari
Publisher: "O'Reilly Media, Inc."
ISBN: 0596519249
Category : Computers
Languages : en
Pages : 172

Book Description
This guide has the detail needed to grasp Microsoft's new querying technology, and concise explanations to help users learn it quickly. For those already applying LINQ, the book serves as an on-the-job reference.

Python Pocket Reference

Author: Mark Lutz
Publisher: "O'Reilly Media, Inc."
ISBN: 144935694X
Category : Computers
Languages : en
Pages : 215

Book Description
Updated for both Python 3.4 and 2.7, this convenient pocket guide is the perfect on-the-job quick reference. Youâ??ll find concise, need-to-know information on Python types and statements, special method names, built-in functions and exceptions, commonly used standard library modules, and other prominent Python tools. The handy index lets you pinpoint exactly what you need. Written by Mark Lutzâ??widely recognized as the worldâ??s leading Python trainerâ??Python Pocket Reference is an ideal companion to Oâ??Reillyâ??s classic Python tutorials, Learning Python and Programming Python, also written by Mark. This fifth edition covers: Built-in object types, including numbers, lists, dictionaries, and more Statements and syntax for creating and processing objects Functions and modules for structuring and reusing code Pythonâ??s object-oriented programming tools Built-in functions, exceptions, and attributes Special operator overloading methods Widely used standard library modules and extensions Command-line options and development tools Python idioms and hints The Python SQL Database API

Oracle and PL/SQL Recipes

Author: Josh Juneau
Publisher: Apress
ISBN: 1430232080
Category : Computers
Languages : en
Pages : 443

Book Description
Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you’re done and home for dinner. Oracle PL/SQL Recipes is another in Apress’ ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy professional who just needs to get the job done. Covers the most common PL/SQL programming problems Presents solutions in ready-to-use format Stays short and to-the-point

HTML5 Pocket Reference

Author: Jennifer Robbins
Publisher: "O'Reilly Media, Inc."
ISBN: 1449368808
Category : Computers
Languages : en
Pages : 184

Book Description
Annotation Need help finding the right HTML5 element or attribute for your web page or application? HTML5 Pocket Reference is the classic reference that web designers and developers have been keeping close at hand for more than thirteen years. This fifth edition has been updated to reflect the current state of HTML5, including the HTML5 Candidate Recommendation, the emerging HTML5.1 Working Draft, and the living WHATWG standard. Features include:An alphabetical listing of every element and attribute in HTML5, HTML5.1, and the WHATWG living standardDescriptions, markup examples, content categories, content models, and start- and end-tag requirements for every elementAt-a-glance notes indicating the differences between the HTML5 specifications and HTML 4.01Useful charts of special charactersAn overview of HTML5 APIsIf youre an experienced web designer or developer who needs a quick resource for working with established web standards, this handy book is indispensable.

Learning SQL

Author: Alan Beaulieu
Publisher: O'Reilly Media
ISBN: 059655107X
Category : Computers
Languages : en
Pages : 338

Book Description
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.