New & Notable
Oracle and SQL News
June 30, 2015
The addition of more than two dozen cloud computing services will allow users to move everything in their data centers to the Oracle cloud, according to CTO Larry Ellison.
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.
Oracle and 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
Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database. Continue Reading
Evaluate Oracle and SQL Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but it does expand functionality in various areas. Continue Reading
Oracle Database 12c's built-in Unified Auditing feature streamlines the database auditing process, including creation and implementation of audit policies. Here's how that works. Continue Reading
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
Manage Oracle and SQL
Learn to apply best practices and optimize your operations.
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
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 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.
Using Oracle ADDM is an effective way to resolve SQL performance problems, according to Brian Peasland. ADDM is his go-to tool for finding problem SQL statements. Continue Reading
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