New & Notable
Oracle and SQL News
July 21, 2014
Oracle Mobile Suite, VM 3.3, Oracle Big Data SQL and Exadata X4-8 are among the exciting new releases Oracle has to offer.
November 29, 2011
Michael McLaughlin, author of Oracle 11g & MySQL 5.6 Developer Handbook discusses the benefits of keyword querying and more in this interview.
September 22, 2009
Oracle made no major architectural enhancements to the 11g R2 database, but it made some useful changes and added some clunkers, too.
September 21, 2007
Oracle SQL Developer is offering a new tool that lets users migrate data from Microsoft and MySQL databases to Oracle.
Oracle and SQL Get Started
Bring yourself up to speed with our introductory content
A correlated subquery is a SQL query that depends on values executed by the outer query in order to complete. Continue Reading
Learn about Oracle PL/SQL stored procedures, such as the stored procedure definition and stored procedure examples 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 Oracle and SQL Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
The new option for the Oracle Big Data Appliance, Oracle Big Data SQL, can simultaneously query Hadoop, NoSQL and SQL data and extend Oracle's management and security tools to all of them. Continue Reading
GenieDB demonstrates its high availability geo-distribution with Phyken Media's Wizard Ops Tactics. Continue Reading
Oracle is offering free tools for Microsoft .NET and ASP.NET applications developers running the Oracle Database 10g. 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
Use Of Solution: I've used it at 3-4 different companies over the last 8 years. Valuable Features: <ul> <li>Ability to search old...Continue Reading
My deployment was expensive due to the complexities I implemented. Other deployments have been less expensive.Powered by IT Central Station
Use Of Solution: 6 years Valuable Features: Workflow configuration (escalation, workflow chaining, conditions, validators, post-scripting,...Continue Reading
Manage Oracle and SQL
Learn to apply best practices and optimize your operations.
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
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Problem Solve Oracle and 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
Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures. Continue Reading