Oracle SQL and PL/SQL Handbook
Author: John Adolph Palinski
Publisher: Addison-Wesley Professional
Published: 2002
Total Pages: 532
ISBN-13: 9780201752946
DOWNLOAD EBOOKCD-ROM contains: Practice database -- Sample scripts reference in text.
Read and Download eBook Full
Author: John Adolph Palinski
Publisher: Addison-Wesley Professional
Published: 2002
Total Pages: 532
ISBN-13: 9780201752946
DOWNLOAD EBOOKCD-ROM contains: Practice database -- Sample scripts reference in text.
Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
Published: 2002
Total Pages: 1028
ISBN-13: 9780596003814
DOWNLOAD EBOOKThe authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.
Author: Michael McLaughlin
Publisher: McGraw Hill Professional
Published: 2014-02-07
Total Pages: 1194
ISBN-13: 007181244X
DOWNLOAD EBOOKMaster 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
Published: 2007-11-26
Total Pages: 178
ISBN-13: 9780596514044
DOWNLOAD EBOOKThe 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: Jonathan Gennick
Publisher: O'Reilly Media
Published: 2000
Total Pages: 104
ISBN-13:
DOWNLOAD EBOOKDespite the wide use of SQL *Plus, few developers and database administrators know how powerful it really is. And the syntax can sometimes be tricky. This portable guide provides a quick reference to subjects such as interacting with SQL *Plus, selecting data, formatting reports, writing scripting, and tuning SQL. There's also a command reference.
Author: Susan Boardman
Publisher: Prentice Hall Professional
Published: 2003
Total Pages: 774
ISBN-13: 9780130477316
DOWNLOAD EBOOKLearn 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: Joel Murach
Publisher: Mike Murach & Associates
Published: 2014
Total Pages: 0
ISBN-13: 9781890774806
DOWNLOAD EBOOKIf you're developing applications that access Oracle databases, you can save time and trouble by having the database do more work for you. That's where this book comes in. It teaches you how to create effective SQL queries to retrieve and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use Oracle's procedural language, PL/SQL, to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer.
Author: Michael McLaughlin
Publisher: McGraw Hill Professional
Published: 2008-04-19
Total Pages: 865
ISBN-13: 0071643567
DOWNLOAD EBOOKDesign Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit
Author: Michael McLaughlin
Publisher: McGraw-Hill Prof Med/Tech
Published: 2011-09-30
Total Pages: 610
ISBN-13: 0071768858
DOWNLOAD EBOOKMaster Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11g and MySQL 5.6 architecture Convert databases between platforms and ensure transactional integrity Create tables, sequences, indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts Execute complex queries and handle numeric and date mathematics Merge data from source tables and set up virtual directories
Author: Michael McLaughlin
Publisher: McGraw Hill Professional
Published: 2010-02-10
Total Pages: 513
ISBN-13: 0071770410
DOWNLOAD EBOOKRamp Up Your PL/SQL Programming Skills Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource. Understand the Oracle development architecture and the mechanics of connections Work with data types, structures, blocks, cursors, and PL/SQL semantics Write, deploy, and use functions, procedures, and packages Manage transactions and more Use dynamic SQL statements in real-world applications Support online transaction processing and data warehousing applications with external tables Find syntax samples and best practices to solve problems Write, deploy, and use object types For a complete list of Oracle Press titles, visit www.OraclePressBooks.com