New & Notable
Using Oracle PL-SQL News
January 08, 2007
Oracle says its newly updated SQL Developer tool includes enhancements that make it easier to create and debug SQL and PL/SQL code.
August 31, 2006
Performance tuning -- keeping your database and SQL queries running quickly and smoothly -- is one of the most important and demanding tasks for an Oracle DBA. This special report compiles analysis, tips and expert advice to help you meet your ...
Using Oracle PL-SQL Get Started
Bring yourself up to speed with our introductory content
SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them. Continue Reading
A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle. Continue Reading
In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). Continue Reading
Evaluate Using Oracle PL-SQL Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
What is the difference between system privileges and object privileges in Oracle? Continue Reading
Manage Using Oracle PL-SQL
Learn to apply best practices and optimize your operations.
Get an explanation of the different types of Oracle joins, including whether there's really a difference between the LEFT JOIN and LEFT OUTER JOIN syntax in PL/SQL. Continue Reading
Oracle Application Express lets users build web applications largely through wizards. Consultant Robert Sheldon explains the process for using the Oracle APEX toolbox. Continue Reading
If you're looking for insert syntax to insert multiple rows in Oracle, read these tips from three of our community members. Continue Reading
Problem Solve Using Oracle PL-SQL Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
What's the difference between DDL and DML? Get the answer and see examples of data manipulation language and data definition language commands for SQL databases. Continue Reading
Read how Oracle Flashback Transaction Query can eliminate the need to use Log Miner to reconstruct database transactions. Continue Reading
Using the SQL CUBE function in Oracle SQL at the right time can cut down on how much querying you'll need to do. Continue Reading