Product Description Steven Feuerstein’s first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle’s procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language — the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages — and how to build them the right way. His “best practices” for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language. Much more than a book, Advanced Oracle PL/SQL Programming with Packages comes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet’s PL/Vision Lite is the first of its kind for PL/SQL developers: . . . More >>
Product Description Designed for any Oracle professional who must quickly implement Oracle reporting, this indispensable guide offers new tips and tricks that make Oracle reporting simple. The basics of PL/SQL are introduced using multiple examples that include code snippets and sample code results. The example-driven methodology teaches PL/SQL language structures, anonymous blocks, and stored procedures so well that by the end of the first chapter users will beÂ¬â€ coding blocks confidently. Exercises are also provided intermittently to test knowledge comprehension. Â¬â€ While gradually building on previous concepts and increasing in complexity, this handbook always focuses on manageability. . . . More >>
This isn’t a tutorial on how to code PL/SQL. It’s designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and won’t break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques. This book sets out to redress the unjust criticism leveled at PL/SQL in years gone by. It gives you the tools and techniques to ensure that, whatever your needs are, the PL/SQL you build will run as efficiently as possible. The practical solutions provided in this book will help you to realize the true power and functionality PL/SQL can offer your projects. Mastering Oracle PL/SQL: Practical Solutions is targeted primarily toward the DBA or developer charged with the implementatio. . . More >>
Notes: Brand New from Publisher. No Remainder Mark.
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 handlingRecords, procedures, functions, triggers, and packagesCalling PL/SQL functions in SQLCompilation 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 intr. . . More >>
This video demonstrates how ‘vulnerable’ Oracle Application Servers can be compromised using OAP_Hacker.pl script. This vulnerability was patched by Oracle in 2006. The idea here is to demonstrate exploitation of PL/SQL injection from web applications. In most instances a PL/SQL Injection in Oracle web app, will result in OS code execution.
This book has been written by giving enormous simple examples of each feature so it is easily understandable for new developers, and there are many advance features that most of the conventional books ignore so it is equally beneficial to the experts. There are more than 400 practical examples, which are being given by the author by keeping in mind the practical problems he himself faced. This book is very useful for the person, who wants to work as an oracle developer, working developer who wants to extend his knowledge and professional or student who intend to give OCP exam. . . . More >>
If you’re developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract 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 PL/SQL to take advantage of powerful features like stor… More >>
Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to th… More >>
You did WHAT? You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to skip over unnecessary lines of code? If slip-ups like these sound familiar (or if you don’t know why these are mistakes), join Quest for a one-hour Webcast featuring guest speaker, Steven Feuerstein, as he examines common mistakes in Oracle PL/SQL programming. Learn how to correct mistakes to improve the maintainability and performance of your application. This Webcast will also demonstrate codexpert â€” a powerful feature available within ToadÂ® that will help you avoid common mistakes and ensure you implement PL/SQL best practices in your daily activities. About the Guest Speaker: Steven Feuerstein is considered one of the world’s leading experts on the Oracle PL/SQL language, having written nine published books on PL/SQL (all from O’Reilly & Associates). Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as a Senior Technology Advisor to Quest Software.