SQL for Accessing, Defining, and Maintaining Data
Oracle SQL provides an easy, elegant, performant architecture for accessing, defining, and maintaining data. Use SQL with Oracle and PHP, Java, Python, .NET, Hadoop, Node.js, or APEX.
Get Started
Key Oracle SQL Features
- Standards compliance: ANSI SQL compliance
- Multi-version read consistency
- Procedural extensions: PL/SQL and Java
- Unleash the full power of queries: Analytic SQL
- Spatial and text
- Performance: indexes, in-memory, partitioning, optimization
Get started with SQL in Oracle Database
- Learn how to create users, grant them privileges, and remove them in Oracle Database
- Manage tables with CREATE TABLE, ALTER TABLE, and DROP TABLE
- Learn how to write SQL queries with SELECT
- Fast data access: How to create and use indexes in Oracle Database
- Ensure data quality: Keys, Constraints and Referential Integrity
- Does your database pass the ACID test? Transactions, Concurrency and Consistency
- Code data logic in the database server: create a PL/SQL stored procedure
- Understand SQL performance: How to create an execution plan | Explain the Explain Plan report (PDF)
Documentation
-
Oracle Database 19c:
Quick Reference, SQL Reference -
Oracle Database 18c:
Quick Reference, SQL Reference -
Oracle Database 12c Release 2:
Quick Reference, SQL Reference -
Oracle Database 12c:
Quick Reference, SQL Reference -
Oracle Database 11gR2:
Quick Reference, SQL Reference - Report: SQL—The Natural Language for Analysis (PDF)