New & Notable
Using Oracle PL-SQL News
September 21, 2007
Oracle SQL Developer is offering a new tool that lets users migrate data from Microsoft and MySQL databases to Oracle.
January 31, 2007
Oracle developers are still talking about their favorite PL/SQL editing and debugging tools, and their opinions aren't confined to just Toad and SQL Develper.
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.
December 12, 2006
The latest version of Oracle's flagship DBMS offers a host of XML-related upgrades.
Using Oracle PL-SQL Get Started
Bring yourself up to speed with our introductory content
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
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
Evaluate Using Oracle PL-SQL Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Dell Toad is pushing itself into business intelligence and now has an edition to support Oracle's big Exadata appliance. Continue Reading
Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen. Continue Reading
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.
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
A reader asks Oracle expert Dan Clamage about a single date condition mucking up a dynamic query. Continue Reading