Database Compatibility for Oracle® Developers SQL Guide

• Introduction
• ALTER DIRECTORY
• ALTER INDEX
• ALTER PROCEDURE
• ALTER PROFILE
• ALTER QUEUE
• ALTER QUEUE TABLE
• ALTER ROLE… IDENTIFIED BY
• ALTER ROLE - Managing Database Link and DBMS_RLS Privileges
• ALTER SEQUENCE
• ALTER SESSION
• ALTER TABLE
• ALTER TRIGGER
• ALTER TABLESPACE
• ALTER USER… IDENTIFIED BY
• ALTER USER|ROLE… PROFILE MANAGEMENT CLAUSES
• CALL
• COMMENT
• COMMIT
• CREATE DATABASE
• CREATE PUBLIC DATABASE LINK
• CREATE DIRECTORY
• CREATE FUNCTION
• CREATE INDEX
• CREATE MATERIALIZED VIEW
• CREATE PACKAGE
• CREATE PACKAGE BODY
• CREATE PROCEDURE
• CREATE PROFILE
• CREATE QUEUE
• CREATE QUEUE TABLE
• CREATE ROLE
• CREATE SCHEMA
• CREATE SEQUENCE
• CREATE SYNONYM
• CREATE TABLE
• CREATE TABLE AS
• CREATE TRIGGER
• CREATE TYPE
• CREATE TYPE BODY
• CREATE USER
• CREATE USER|ROLE… PROFILE MANAGEMENT CLAUSES
• CREATE VIEW
• DELETE
• DROP DATABASE LINK
• DROP DIRECTORY
• DROP FUNCTION
• DROP INDEX
• DROP PACKAGE
• DROP PROCEDURE
• DROP PROFILE
• DROP QUEUE
• DROP QUEUE TABLE
• DROP SYNONYM
• DROP ROLE
• DROP SEQUENCE
• DROP TABLE
• DROP TABLESPACE
• DROP TRIGGER
• DROP TYPE
• DROP USER
• DROP VIEW
• EXEC
• GRANT
  • GRANT on Database Objects
  • GRANT on Roles
  • GRANT on System Privileges
• INSERT
• LOCK
• REVOKE
• ROLLBACK
• ROLLBACK TO SAVEPOINT
• SAVEPOINT
• SELECT
  • FROM Clause
  • WHERE Clause
  • GROUP BY Clause
  • HAVING Clause
  • SELECT List
  • UNION Clause
  • INTERSECT Clause
  • MINUS Clause
  • CONNECT BY Clause
  • ORDER BY Clause
  • DISTINCT | UNIQUE Clause
  • FOR UPDATE Clause
• SET CONSTRAINTS
• SET ROLE
• SET TRANSACTION
• TRUNCATE
• UPDATE
• Conclusion