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.
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 ...
November 25, 2003
Application development tip #5 from "30 Oracle tips in 30 minutes," brought to you by the IOUG.
Oracle and 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
Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading
Java Database Connectivity (JDBC) is an API packaged with the Java SE edition that makes it possible to connect from a Java Runtime Environment (JRE) to external, relational database systems. 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
Manage Oracle and 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
Read how Oracle Flashback Transaction Query can eliminate the need to use Log Miner to reconstruct database transactions. 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
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