SQL for Accessing, Defining, and Maintaining Data
Oracle SQL provides an easy, elegant, performant architecture for accessing, defining, and maintaining data. Use Oracle SQL with PHP, Java, Python, .NET, Hadoop, Node.js, and Oracle 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)
Additional Resources
- Related Information