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 Type | SQL Statement | Supported in Oracle? | Supported in PostgreSQL? |
---|---|---|---|
DDL | CREATE | Yes | Yes |
DDL | ALTER | Yes | Yes |
DDL | DROP | Yes | Yes |
DDL | TRUNCATE | Yes | Yes |
DDL | RENAME | Yes | Yes |
DML | INSERT | Yes | Yes |
DML | UPDATE | Yes | Yes |
DML | DELETE | Yes | Yes |
DML | MERGE | Yes | No |
DQL | SELECT | Yes | Yes |
DCL | GRANT | Yes | Yes |
DCL | REVOKE | Yes | Yes |
TCL | COMMIT | Yes | Yes |
TCL | ROLLBACK | Yes | Yes |
TCL | SAVEPOINT | Yes | Yes |