Compatible SQL commands v17

Suggest edits

EDB Postgres Advanced Server supports many SQL commands compatible with Oracle databases. These SQL commands work on both an Oracle database and an EDB Postgres Advanced Server database.

EDB Postgres Advanced Server supports additional commands not described here. These commands might not have an Oracle equivalent, or they might provide the similar or same functionality as an Oracle SQL command but with different syntax.

The SQL commands that follow don't necessarily represent the full syntax, options, and functionality available for each command. In most cases, syntax, options, and functionality that aren't compatible with Oracle databases aren't included in the command description and syntax.

Command functionality that isn't compatible with Oracle databases is noted.

ALTER CAPTURE PRIVILEGE POLICY

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 SYNONYM

ALTER TABLE

ALTER TRIGGER

ALTER TABLESPACE

ALTER USER… IDENTIFIED BY

ALTER USER|ROLE… PROFILE MANAGEMENT CLAUSES

CALL

COMMENT

COMMIT

CREATE CAPTURE PRIVILEGES POLICY

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 CAPTURE PRIVILEGES POLICY

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

INSERT

MERGE

LOCK

REVOKE

ROLLBACK

ROLLBACK TO SAVEPOINT

SAVEPOINT

SELECT

SET CONSTRAINTS

SET ROLE

SET TRANSACTION

TRUNCATE

UPDATE

← Prev

PG_USER

↑ Up

Oracle compatibility reference

Next →

ALTER CAPTURE PRIVILEGE POLICY