---
name: "oracle_compat"
section: "3"
platform: "linux"
package: "postgresql-dev"
version: "6.3.2-15"
release: "Debian 2.1 (Slink)"
platforms: ["linux"]
url: "https://new.carta.tech/oracle_compat"
---

# oracle\_compat(3)

## DESCRIPTION

This is a set of single row character functions, defined for the datatype  text. They are supposed to behave exactly as their Oracle counterparts.

The following functions have been implemented:

**LOWER(string)**

-

  Returns string, with all letters forced to lowercase.

**UPPER(string)**

-

  Returns string, with all letters forced to uppercase.

**INITCAP(string)**

-

  Returns string, with first letter of each word in uppercase, all other letters in lowercase. A word is delimited by white space.

**LPAD(string1, len \[,string2\])**

-

  Returns string1, left-padded to length len with the sequence of characters in string2. string2 defaults to blanks.

**RPAD(string1, len \[,string2\])**

-

  Returns string1, right-padded to length len with the sequence of characters in string2. string2 defaults to blanks.

**LTRIM(string \[,set\])**

-

  Returns string with initial characters removed up to the first character not in set. set defaults to blanks.

**RTRIM(string \[,set\])**

-

  Returns string with final characters removed after the last character not in set. set defaults to blanks.

**SUBSTR(string, m \[,n\])**

-

  Returns a portion of string, beginning at character m, n characters long. If n is omitted, to the end of the string. The first position of string is 1.

**TRANSLATE(string, from, to)**

-

  Returns string after replacing all occurences of from with the corresponding character in to. TRANSLATE will not remove characters.