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.
June 14, 2007
Oracle is offering free tools for Microsoft .NET and ASP.NET applications developers running the Oracle Database 10g.
March 26, 2007
Oracle Application Express now offers Microsoft Access migration and .pdf printing support.
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.
Using Oracle PL-SQL Get Started
Bring yourself up to speed with our introductory content
If you're looking for insert syntax to insert multiple rows in Oracle, read these tips from three of our community members. Continue Reading
Learn about PL/SQL datatypes in Oracle, and learn the definitions of BLOB, CLOB, DATE, VACHAR2 and more in this PL/SQL tutorial for beginners and experts. Continue Reading
Learn about using Oracle PL/SQL functions and triggers, such as how to import a trigger and how and when to use a PL/SQL function in this PL/SQL tutorial. 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
The latest version of Oracle's flagship DBMS offers a host of XML-related upgrades. Continue Reading
Product ReviewsPowered by IT Central Station
Pros: Flexible, Open-ended, Useful default values and fields. Cons: Deep and complex, it takes a while to familiarizePowered by IT Central Station
Want Project Management Tool? I tried OpenProject.org and got frustrated with its performance (because it's Ruby-based ?) and skimpy features. ...Continue Reading
Our development team and it's functional staff have gained a better overview of the issues that are being worked onPowered by IT Central Station
Valuable Features: <ul> <li>Ability to search old issues.</li> <li>Ability to create your own tags and fields, ie...Continue Reading
My deployment was expensive due to the complexities I implemented. Other deployments have been less expensive.Powered by IT Central Station
Valuable Features: Workflow configuration (escalation, workflow chaining, conditions, validators, post-scripting, etc) Improvements To...Continue Reading
Manage Using Oracle PL-SQL
Learn to apply best practices and optimize your operations.
Find the definition for different types of Oracle joins, and read a discussion on LEFT JOIN vs. LEFT OUTER JOIN in this expert Q/A. 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
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.
A reader asks Oracle expert Dan Clamage about a single date condition mucking up a dynamic query. Continue Reading
Learn how to do simple SQL arithmetic operations without using the arithmetic operators. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading