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

SQL Clauses

SQL in Oracle and PostgreSQL, offers a handful of Clauses to use in conjunction with SQL statements.

This chapter describes you the types of SQL clauses 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.

SQL ClauseSupported in Oracle?Supported in PostgreSQL?
FROMYesYes
WHEREYesYes
ORDER BYYesYes
GROUP BYYesYes
HAVINGYesYes
WITHYesYes
DISTINCTYesYes
INTOYesYes
LIMITNoYes
OVERYesYes
Was this article helpful to you? Yes 1 No

How can we help?