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, 3:00]
PL/SQL Enhancements in Oracle Database 11g
White Papers Oracle Database 11g brings PL/SQL enhancements in these categories: transparent and "Knob-controlled" performance improvements; new language features that one uses in the programs to get better performance; new language features that bring...
[January 9, 2008, 0:01]
PL/SQL Developer
Downloads PL/SQL Developer is an integrated development environment for developing, testing, debugging, and optimizing Oracle PL/SQL stored-program units such as packages, triggers, and so on. This update includes a new Project concept, HTML Reports, Export...
[April 26, 2008, 9:02]
Working With PL/SQL
White Papers Among its other features, Oracle SQL Developer provides database developers and DBAs with a comprehensive environment for creating, editing, compiling, running, and debugging PL/SQL program units. This column introduces Oracle SQL Developer's key...
[March 20, 2008, 0:02]
Using PL/SQL Associative Arrays
White Papers And second, applications that use Oracle databases must use PL/SQL for access to the database structures. Knowing that one needs to use PL/SQL in the database as the Application-Programming Interface (API) and that one needs to reduce network usage...
[March 20, 2008, 0:02]
Debugging PL/SQL From .NET
White Papers Debugging PL/SQL code in Microsoft Visual Studio is as easy as debugging native .NET code, thanks to the PL/SQL debugger in Oracle Developer Tools for Visual Studio .NET (ODT). This paper demonstrates how to set up PL/SQL debugging in ODT and how...
[October 11, 2006, 1:00]
Log4plsql: Open-Source Tool for PL/SQL Logging
White Papers This paper explains the usefulness of PL/SQL logging and introduces the open-source Log4plsql tool - an extension of the popular Apache Log4j Java logging project - which offers all the tools and methods required for the management of logs and...
[October 13, 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]
Oracle PL/SQL Developer's Workbook: Triggers
White Papers A trigger is a block of code (whether in PL/SQL, Java, or C) that fires, or executes, in response to a specific event. A trigger executes implicitly in response to an event, such as an update to a table.
[October 17, 2007, 1: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, 1:00]
Efficient Use of PL/SOL String Functions for Unicode Applications
White Papers This white paper focuses on performing implications of PL/SQL applications for Unicode database server using a UTF-8 database character set. The paper also analyzes the costs of using PL/SQL string functions on different types of character set...
[March 2, 2004, 11:20]
More on Oracle Database 11g
White Papers PL/SQL is Oracle's procedural extension to SQL, and it is a true 3GL programming language. The ability to store PL/SQL in the database came with version 7 in 1992. Today, PL/SQL is competent, mature, and full-featured, offering everything one...
[March 29, 2008, 0:01]
Strings Attached
White Papers Many PL/SQL programs manipulate data, often by using SQL to work with that data directly in the database. Yet a person often needs to declare and manage data within PL/SQL programs themselves. To create and manage these lists, PL/SQL offers a...
[October 13, 2006, 0:00]
SwisSQL--Sybase to Oracle Edition
Downloads SwisSQL Sybase to Oracle Edition is an automated migration tool to convert stored procedures implemented in Sybase Adaptive Server Transact SQL into equivalent PL/ SQL code. It automates more than 90% of the Sybase Transact SQL code conversion into...
[March 25, 2005, 15:31]
Oracle JDeveloper for Database Developers and DBAs
White Papers Oracle JDeveloper 10g is an Integrated Development Environment providing end-to-end support for building, testing, and deploying J2EE applications, Web services, and PL/SQL. This paper describes the features for PL/SQL development, working online...
[August 4, 2005, 6:00]
Translating Procedural Statements Between Oracle and SQL Server
White Papers This white paper is intended to give a QUICK but thorough overview of the issues database users may encounter when translating procedural code, such as stored procedures or user-defined functions, between Oracle's PL/SQL and Microsoft SQL Server's...
[September 15, 2003, 17:01]
Using PHP to Create Custom SSO Login and Sign-Off Pages
White Papers If a person has installed Oracle Application Server 10g Enterprise Edition and are ready to create custom SSO login and sign-off pages, then he or she might want to consider using PHP over the traditional PL/SQL and JSP methods.
[October 17, 2006, 1: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]
OraDeveloper Tools for VS 2005
Downloads Optimized for PL/SQL development with an SQL and PL/SQL debugger, code completion, code templates, and project management support. Powerful Visual Studio add-in designed to automate and simplify the process of developing applications with Oracle.
[July 13, 2007, 12:45]
Virtualize Your Oracle Database With Web Services
White Papers Oracle Database 10g supports both modes - in consumer mode generating Java proxy classes and PL/SQL wrappers and loading the appropriate files in the database for a given Web Services Definition Language (WSDL) file, and in provider mode allowing...
[October 13, 2006, 1:00]
