Previous
PL/SQL Performance - Debunking The Myths
White Papers This whitepaper is intended for readers who work at the PL/SQL code-face. Oracle Database 10g introduced a brand-new optimizing PL/SQL compiler and a newly tuned PL/SQL execution environment so that PL/SQL programs run dramatically faster.
[October 4, 2005, 0:00]
Self-Managing PL/SQL
White Papers Given that achievement and direction, it would make sense to talk about how to write one's PL/SQL application so that it is also self-managing. Oracle has introduced significant management automation features in its flagship database product and...
[October 17, 2006, 0:00]
Refactoring For PL/SQL Developers
White Papers Most PL/SQL developers stay very busy building applications. As a result, relatively few explore the wider world of software programming, in which the topic of refactoring is known. Refactoring is the process of changing a software system in such a...
[October 17, 2006, 0:00]
Oracle Database 10g: Top Features For DBAs - Part 1: SQL And PL/SQL Features
White Papers The paper presents SQL and PL/SQL features of Oracle Database 10g such as enhanced COMMIT, error-logging clause, WRAP package, conditional compilation, and unlimited DBMS Output. Transparent Data Encryption and XQuery support are the two major new...
[October 11, 2006, 0:00]
An Introduction To PL/SQL
White Papers PL/SQL is a powerful and complex programming language. The use of cursors to interact with the database, using packages to improve performance and efficiency, using PL/SQL tables and other collections are just a small part of what remains for the...
[August 6, 2007, 0:00]
Oracle PL/SQL Developer's Workbook: Problems
White Papers A trigger is a special PL/SQL procedure that fires, or executes, in response to a specific triggering event. For example, one might write a trigger to enforce a business rule on INSERT statements on a particular table, maintain referential...
[October 18, 2007, 0:00]
Advanced Techniques For PL/SQL In The World Of Web Services
White Papers Many have wondered about PL/SQL, the language of the Oracle9i. Given PL/SQL has been used literally for decades for constructing high performance database business logic in Oracle databases, is there a way to expose that functionality to the world...
[November 14, 2007, 23:00]
Oracle PL/SQL: Managing PL/SQL Code
White Papers When one compiles PL/SQL programs, the source code is loaded into the data dictionary in a variety of forms (the text of the code, dependency relationships, parameter information, etc. One can therefore use SQL to query these dictionary views to...
[October 17, 2007, 0:00]
Taking Up Collections
White Papers During its lifetime, Oracle PL/SQL has become faster, easier to use, and richer in its feature set. Oracle Database 10g continues this PL/SQL tradition of speed, ease, and feature growth by offering a useful array of enhancements.
[October 12, 2006, 0:00]
Controlling Mythological Code
White Papers They are just a few of the myths that are perpetuated in the PL/SQL applications. This paper explodes a variety of the most pernicious PL/SQL myths, shows how to systematically remove them, and offers advice about how to avoid writing today what...
[October 17, 2006, 0:00]
Better To Best NDS
White Papers In recent years, dynamic SQL has become a much more common aspect of PL/SQL programming. Prior to the availability of Native Dynamic SQL (NDS) in Oracle8i, dynamic SQL was available in PL/SQL only through the DBMS_SQL package.
[October 17, 2006, 0:00]
Picking Your Packages
White Papers The Oracle PL/SQL language is a joy to use; it is a straightforward and eminently readable programming tool. One of the most important and useful elements of PL/SQL is the package. In the early days of PL/SQL, many developers were unfamiliar with...
[October 17, 2006, 0:00]
Wrapping Your Brain Around Oracle + Python
White Papers PL/SQL is ideal for programming tasks within Oracle Database. The users have probably encountered many tasks for which PL/SQL has proven clumsy or even unusable - such as manipulating files on disk, invoking external programs or shell scripts...
[October 17, 2006, 0:00]
VERITAS DBMS Technical Brief: Using Oracle DBMS_SESSION And DBMS_APPPLICATION_INFO Built-In Packages
White Papers Each new release of Oracle adds to the already rich set of built-in packages as a standard part of PL/SQL functionality. The Oracle PL/SQL built-in packages (a.k.a.the DBMS packages) are a virtual treasure trove of useful and powerful constructs...
[November 13, 2007, 23:00]
New Attack Technique Puts Oracle In Crosshairs
News It was previously thought that an attacker needed high-level privileges on the database to exploit so-called PL SQL injection vulnerabilities. In the past, PL SQL injection flaws often required a "create procedure" privilege on the database, which...
[March 2, 2007, 8:02]
Oracle Database Flaws Affect Virtually All Financial Transactions
News According to the WSJ, Litchfield found problems in the PL/SQL code, which is used by custom applications to communicate with the database. If this is going to affect PL/SQL code, there is an awful lot of home-grown PL/SQL code out there -- it's not...
[August 3, 2004, 17:25]
Integrating Oracle And Java: Optimising Your Development Platform For ERP Apps
News You have new possibilities open to you that PL/SQL never provided: A JSP can run operating system programs from within the database. There is little that PL/SQL can do for you, external procedurewise, that Java won't do better.
[June 6, 2003, 11:05]
Oracle Revamps DBA Certification
News The original five exams required of Oracle8i OCP candidates -- Introduction to Oracle: SQL and PL/SQL (1Z0-001); Oracle8i: Architecture and Administration (1Z0-023); Oracle8i: Backup and Recovery Workshop (1Z0-025); Oracle8i: Performance Tuning...
[September 9, 2002, 11:15]
Creating XML From MySQL As Easy As PI
News Conversely, you can use the module to read an XML file, create a SQL query, and execute it. Other languages, particularly Web scripting languages, haven't ignored the need to import XML into SQL databases either.
[June 20, 2002, 17:23]
TechNet Webcast: How To Migrate Your Oracle Database To SQL Server (Level 200)
White Papers Have you ever wondered how to take PL/SQL code and convert it to T-SQL? This webcast presents a new tool to you called Microsoft SQL Server Migration Assistant (SSMA). SSMA automates the conversion of Oracle Database schema and data to Microsoft...
[October 29, 2007, 23:00]
