PostgreSQL-oracle适配-orafce插件学习笔记

官方文档学习

数据类型

Item	Overview
VARCHAR2	Variable-length character data type
NVARCHAR2	Variable-length national character data type
DATE	Data type that stores date and time

差异说明

Item	Standard feature of PostgreSQL	Compatibility feature added by orafce
DATE	Stores date only.	Stores date and time.

函数

**详细说明：**https://github.com/orafce/orafce/blob/master/doc/orafce_documentation/Orafce_Documentation_05.md

• 数学函数

Item	Overview
BITAND	Performs a bitwise AND operation
COSH	Calculates the hyperbolic cosine of a number
SINH	Calculates the hyperbolic sine of a number
TANH	Calculates the hyperbolic tangent of a number

• 字符串函数

Item	Overview
INSTR	Returns the position of a substring in a string
LENGTH	Returns the length of a string in number of characters
LENGTHB	Returns the length of a string in number of bytes
LPAD	Left-pads a string to a specified length with a sequence of characters
LTRIM	Removes the specified characters from the beginning of a string
NLSSORT	Returns a byte string used to sort strings in linguistic sort sequence based on locale
RPAD	Right-pads a string to a specified length with a sequence of characters
RTRIM	Removes the specified characters from the end of a string
SUBSTR	Extracts part of a string using characters to specify position and length
SUBSTRB	Extracts part of a string using bytes to specify position and length

• 日期/时间函数

Item	Overview
ADD_MONTHS	Adds months to a date
DBTIMEZONE	Returns the value of the database time zone
LAST_DAY	Returns the last day of the month in which the specified date falls
MONTHS_BETWEEN	Returns the number of months between two dates
NEXT_DAY	Returns the date of the first instance of a particular day of the week that follows the specified date
ROUND	Rounds a date