1. Home
  2. Docs
  3. Oracle to PostgreSQL Migration
  4. 3 Built-in Functions
  5. 3.2 Similar Functions

3.2 Similar Functions

These are the functions which exist in both Oracle and PostgreSQL database. The name and operations are also same in both the databases.

Following are the list of functions which behave the same in Oracle and PostgreSQL. So, while migrating from an Oracle database to PostgreSQL, you need not worry on converting these functions.

Character Functions

Built-in functionDescriptionOraclePostgres
UPPERIt converts character values to upper case.SELECT upper(‘db Migration’) FROM DUAL;SELECT upper(‘db Migration’);
LOWERIt converts character values to lower case.SELECT lower(‘db Migration’) FROM DUAL;SELECT lower(‘db Migration’);
INITCAPIt takes a string and converts first character of each word to upper case and keeps all other letters in lower case. For INITCAP, words are delimited either by white space or characters that are not alpha-numeric.select initcap(‘Data.base mig-r$ation’) FROM DUAL;select initcap(‘Data.base mig-r$ation’);
LENGTHDifference
CONCATDifferenceSELECT concat(‘Database’, ‘Migration’) FROM DUAL;SELECT concat(‘Database’, ‘Migration’);
SUBSTRDifferencesubstr(‘Database Migration’, 1, 5)
INSTRNot Available
LTRIM
RTRIM
TRIM
LPAD
RPAD
REPLACE
TRANSALTE
CHR
ASCII
SOUNDEX
COALESCE

Number Functions

Built-in functionDescriptionExample
ABS
CEIL
FLOOR
MOD
ROUND
COALESCE
CASE

Date and Time Functions

Built-in functionDescriptionExample
Was this article helpful to you? Yes No

How can we help?