1. Home
  2. Docs
  3. Oracle to PostgreSQL Migration
  4. 1 Database Migration Basics
  5. 1.3 SQL Statements

1.3 SQL Statements

SQL in Oracle and PostgreSQL, consists of several commands, preferably called as SQL statements. The SQL statements can be used to perform almost all the database operations in Oracle and PostgreSQL.

This section describes you the types of commands available in Oracle and PostgresSQL. The “Supported in Oracle?” column in the table below indicates whether the feature is supported in Oracle. Similarly, “Supported in PostgreSQL?” column indicates whether the feature is supported in PostgreSQL database or not.

Command TypeSQL StatementSupported in Oracle?Supported in PostgreSQL?
DDLCREATEYesYes
DDLALTERYesYes
DDLDROPYesYes
DDLTRUNCATEYesYes
DDLRENAMEYesYes
DMLINSERTYesYes
DMLUPDATEYesYes
DMLDELETEYesYes
DMLMERGEYesNo
DQLSELECTYesYes
DCLGRANTYesYes
DCLREVOKEYesYes
TCLCOMMITYesYes
TCLROLLBACKYesYes
TCLSAVEPOINTYesYes
Was this article helpful to you? Yes No

How can we help?