Book Description
CD-ROM contains: Practice database -- Sample scripts reference in text.
Author : John Adolph Palinski
Publisher : Addison-Wesley Professional
Page : 532 pages
File Size : 35,80 MB
Release : 2002
Category : Computers
ISBN : 9780201752946
CD-ROM contains: Practice database -- Sample scripts reference in text.
Author : Steven Feuerstein
Publisher : "O'Reilly Media, Inc."
Page : 1028 pages
File Size : 30,32 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 : Dan Hotka
Publisher : McGraw Hill Professional
Page : 257 pages
File Size : 10,54 MB
Release : 2006-10-31
Category : Computers
ISBN : 0071631569
There have been more than 100,000 downloads of Oracle SQL Developer SQL and PL/SQL are the most popular development languages for the Oracle database
Author : Michael McLaughlin
Publisher : McGraw Hill Professional
Page : 1194 pages
File Size : 25,29 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 : Susan Boardman
Publisher : Prentice Hall Professional
Page : 774 pages
File Size : 22,41 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 : Michael Rosenblum
Publisher : Apress
Page : 507 pages
File Size : 36,61 MB
Release : 2011-12-10
Category : Computers
ISBN : 1430234865
Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine
Author : Michael McLaughlin
Publisher : McGraw Hill Professional
Page : 513 pages
File Size : 42,22 MB
Release : 2010-02-10
Category : Computers
ISBN : 0071770410
Ramp 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
Author : Joel Murach
Publisher : Mike Murach & Associates
Page : 0 pages
File Size : 50,85 MB
Release : 2014
Category : Computers
ISBN : 9781890774806
If 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 : Jonathan Gennick
Publisher : O'Reilly Media
Page : 104 pages
File Size : 36,51 MB
Release : 2000
Category : Computers
ISBN :
Despite 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 : Michael Rosenblum
Publisher : John Wiley & Sons
Page : 443 pages
File Size : 31,48 MB
Release : 2006-06-13
Category : Computers
ISBN : 0764599577
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