Overview


This document compares the features of Altibase version 7.1 or later with Oracle 12c.

For errors and improvements related to this document, please contact the technical support portal or technical support center.

Model Comparison


Let's compare the overall model of Altibase and Oracle.

Architecture


FeatureOracleAltibaseRemark
Database StructureMulti-process structureMulti-thread structure 
ModelRelational database structureRelational database structure 
ArchitectureClient-server architectureClient-server architecture 
ReplicationReal Application Cluster (RAC)Data ReplicationAltibase replication replicates only table data
Individual instanceInternal thread
Shared storageSeparate storage
Shared schemaSeparate schema
Shared dataData replication
64bit mode supportSupportedSupported
Locking modeRow-Level LockingRow-Level LockingMVCC supported
Database recoveryUse Checkpoint & LogfileUse Checkpoint & Logfile 
DeadLock Detection(Auto Deadlock Detect & Recovery)(Auto Deadlock Detect & Recovery) 

Logical Structure


FeatureOracleAltibaseRemark
Management StructureDatabase(DB)Database(DB)Altibase is a single database
TablespaceTablespace 
SegmentSegment 
ExtentExtent 
BlockPage 
RowRecord 
System TablespaceData DictionarySYSTEM, SYSAUXSYS_TBS_MEM_DIC 
UndoUNDOTBSSYS_TBS_DISK_UNDO 
Memory Data-SYS_TBS_MEM_DATA 
TempTEMPSYS_TBS_DISK_TEMP 
Disk DataSYSTEMSYS_TBS_DISK_DATA 
User TablespaceUndoSpecified by userGlobal Undo Tablespace 
Memory DataSpecified by userSpecified by userThis is possible in Oracle by setting the memory option
TempSpecified by userSpecified by user 
Disk DataSpecified by userSpecified by user 
Volatile DataNot availableSpecified by user 

Physical Structure


FeatureOracleAltibaseRemark
Data FileData FileData File 
Data Information FileControl FileLog Anchor File 
Online Log FileOnline Log File (Recycle)Online Log File (Serial) 
Archive Log File%t_%s_%r.arclogfile0 ~It is a replicate of the online log file, with the same name and different storage locations.

Considerations/Notes


FeatureOracleAltibaseRemark
Length of object name128 Byte40 Byte 
Number of tablespaces65,53365,533Maximum number per database
Number of database filesOperating system dependent; usually 1,0221024Maximum per tablespace
65,53367,108,864Maximum per database
Number of users2,147,483,6382,147,483,638Maximum per database
Number of tablesUnlimited2,097,151Maximum per database
Number of indexesUnlimited64Maximum per table
Number of Columns1,0001024Per table
3232Per index
Trigger Cascade LimitOperating system-dependent, typically 32UnlimitedMaximum value
Number of rowsUnlimitedUnlimited 
Number of partitionsUnlimited

System-wide

2,097,151

Not divided into table units
Number of constraintsUnlimited

System-wide

2,097,151

Not divided into in column units

Feature Comparison


Let's compare the common features between Altibase and Oracle.

Supported function


FeatureOracleAltibaseRemark
TableSupportedSupported 
Multi Key-IndexSupportedSupported 
Stored ProcedureSupportedSupported 
Stored FunctionSupportedSupported 
PackageSupportedSupported 
TriggerSupportedSupported 
ViewSupportedSupportedIncluding Materialized View
SequenceSupportedSupported 
QueueSupported (Advanced Queue)Supported 
Monitoring ViewSupportedSupported 
Authority ManagementSupportedSupported 
RoleSupportedSupported 
SnapshotSupportedNot supported 
DB LinkSupportedSupportedSupported by standard JDBC
SynonymSupportedSupported 
Table partitioningSupportedSupportedGlobal Non Partitioned Index Supported
User Defined TypeSupportedPartially SupportedOnly supported in Procedure
Cluster ObjectSupportedNot supported 
On-Line BackupSupportedSupported 
XMLSupportedNot supported 
Auto Expansion of DB spaceSupportedSupported 

Supported tool


FeatureOracleAltibaseRemark
GUI Admin ToolOEM and various 3rd party productsSquirrel SQL, Orange available 
Interactive SQL ProcessorSQL*PlusiSQL 
Data LoaderSQL*LoaderiLoader 
DMBS Admin TOOLSQL*PlusiSQL 
Data Transferexp/impiLoader/aexportDownload / Upload as text type data
Connection DispatcherListenerEmbedded in DBMS 
DB CreateDBCAiSQL 
DB DestroyerNot availableiSQL 
C PrecompilerPro*C/C++APRE*C/C++ 
Recovery ManagerRMANiSQL, aexport, iLoaderConnection with storage company tools (API provided)
DBMS checkServer 

Partition Table


ClassificationFeatureOracleAltibaseRemark
Type (MethodRANGE partitionSupportedSupported 
LIST partitionSupportedSupported 
HASH partitionSupportedSupported 
COMPOSITE partitionSupportedNot supported 
Management commandALTER tablespace-SupportedRefer to details of the partition table function
ADD partitionSupportedPartially supported
COALESCE partitionSupportedPartially supported
DROP partitionSupportedSupported
SPLIT partitionSupportedSupported
MERGE partitionSupportedSupported
TRUNCATE partitionSupportedSupported
RENAME partitionSupportedSupported
EXCHANGE partitionSupportedNot supported
MODIFY partitionSupportedNot supported
MOVE partitionSupportedNot supported
IndexGlobal IndexSupportedPartially supportedGlobal Non Partitioned index supported
 Local IndexSupportedSupported 

Partition table feature details


Operations based on Altibase partition type (method)

OperationRangeListHash
Alter tablespaceALTER TABEL PARTITIONALTER TABLE PARTITIONALTER TABLE PARTITION
ADDN/AN/AADD PARTITION
COALESCEN/AN/ACOALESCE PARTITION
DROPDROP PARTITIONDROP PARTITIONN/A
MERGEMERGE PARTITIONSMERGE PARTITIONSN/A
RENAMERENAME PARTITIONRENAME PARTITIONRENAME PARTITION
SPLITSPLIT PARTITIOnSPLIT PARTITIONN/A
TRUNCATETRUNCATE PARTITIONTRUNCATE PARTITIONTRUNCATE PARTITION

Operations based on Oracle partition type (method)

OperationRangeListHashComposite
Range-HashRange-List
ADDADD PARTITIONADD PARTITIONADD PARTITION

ADD PARTITION,

MODIFY PARTITION ... ADD SUBPARTITION

ADD PARTITION,

MODIFY PARTITION

SUBPARTITION

COALESCEN/AN/ACOALESCE PARTITIONMODIFY PARTITION ... COALESCE SUBPARTITION

 

N/A

 

DROPDROP PARTITION DROP PARTITION N/A DROP PARTITION DROP [SUB]PARTITION 
MERGEMERGE PARTITIONSMERGE PARTITIONSN/AMERGE PARTITIONSMERGE [SUB]PARTITION
RENAMERENAME PARTITIONRENAME PARTITIONRENAME PARTITIONRENAME [SUB]PARTITIONRENAME [SUB]PARTITION
SPLITSPLIT PARTITIONSPLIT PARTITIONN/ASPLIT PARTITIONSPLIT [SUB]PARTITION
TRUNCATETRUNCATE PARTITIONTRUNCATE PARTITIONTRUNCATE PARTITIONTRUNCATE [SUB]PARTITIONTRUNCATE [SUB] PARTITION
EXCHANGEEXCHANGE PARTITIONEXCHANGE PARTITIONEXCHANGE PARTITIONEXCHANGE [SUB] PARTITIONEXCHANGE [SUB] PARTITION
MOVEMOVE PARTITIONMOVE PARTITIONMOVE PARTITIONMOVE SUBPARTITIONMOVE SUBPARTITION

Backup & Recovery


FeatureOracleAltibaseRemark
Online Backup (Hot)SupportedSupported 
Offline Backup (Cold)SupportedSupported 
Table-by-table BackupSupportedSupported 
Incomplete BackupSupportedSupported 
Complete BackupSupportedSupported 
Specific Tablespace RecoverySupportedSupported 
Incremental BackupSupportedSupported 
Text Data Backup & RecoverySupportedPartially supportedObject and Data Text available with aexport

Development Support Comparison


This section describes a comparison of features that can be referred to when developing by converting Oracle to Altibase.

SQL Support


FeatureOracleAltibaseRemark
SQL

Standard SQL, Transform SQL

(Support ANSI-SQL92, ANSI-SQL1999)

Standard SQL

(Support ANSI-SQL92)

Object-oriented features of ANSI-SQL1999 are not supported
Sub-query(In-Line View)SupportedSupported 
Sub-query(Scalar)SupportedSupported 
Sub-query(=,IN,EXISTS)SupportedSupported 
Equi JoinSupportedSupported 
Inner JoinSupportedSupported 
Outer JoinSupportedSupportedOracle (+) is also supported
Self JoinSupportedSupported 

Hierarchical query

CONNECT BY ~ WITH

SupportedSupportedCONNECT_BY_ISYCYCLE is not supported
Array ProcessingSupportedSupported 
Move statementNot supportedSupported 
QueueAdvanced QueueEnqueue/DequeueDifferences in statement/method used
SELECT ~ FOR UPDATESupportedSupportedJoin is not supported
SELECT DISTINCT ~SupportedSupported 
UNIONSupportedSupported 
UNION ALLSupportedSupported 
INTERSECTSupportedSupported 
MINUSSupportedSupported 
CERATE TABLE AS SELECT ~SupportedSupported 
Literal/Bind SQLSupportedSupported 
DML with VIEWSupportedSupported 
WHERE REGEXP_LIKE ConditionSupportedSupported 
Hint functionSupportedSupported 
Cost OptimizerSupportedSupported 
Parallel SelectSupportedSupported 
Parallel InsertSupportedSupported 
Parallel Index BuildSupportedSupported 

Data Type Comparison


ClassificationOracleAltibase
Data typeDescriptionData TypeDescription
Character TypeCHARFixed-length character type. Up to 2000 bytesCHARFixed-length character type. Up to 32K
VARCHAR2Variable-length character type. Up to 4000 bytesVARCHARVariable-length character type. Up to 32K
NCHAR

Unicode fixed-length character type.
Up to 2000 bytes

NCHAR

Character length up to 16000 (UTF16),

Character length up to 10666 (UTF8)

NVARCHAR2

Unicode variable-length character type.

Up to 4000 bytes

NVARCHAR

Character length up to 16000 (UTF16),

Character length up to 10666 (UTF8)

LONGCharacter type, Up to 2G Can be replaced with CLOB
LOB TypeBLOB

Single binary type.

Max: (4G-1) * (database block size)

BLOBUp to 2G
CLOB

Single byte character type.

Max: (4G-1) * (database block size)

CLOBUp to 2G
NCLOB

Unicode character type.

Max: (4G-1) * (database block size)

 Can be replaced with CLOB
Numeric TypeNUMERIC(p, s)

Numeric type.
Accuracy p 1 to 38, scale s -87 to 127

NUMERIC(p, s)

Fixed point.

Accuracy p 1 to 38, scale s -84 to 128

NUMBER (p, s) NUMBER(p, s)Same as FLOAT if p and s are not specified. Given p or p, s is the same as NUMERIC
DECIMAL(p, s) DECIMAL(p, s)Same as NUMERIC (p, s)

FLOAT(p),

BINARY_FLOAT

 FLOAT(p)Floating point. Only precision (p) can be specified
SMALLINT SMALLINT2 byte integer type
INT INTEGER4 byte integer type
  BIGINT8 byte integer type
REAL REAL4 byte real type
DOUBLE, BINARY_DOUBLE DOUBLE8 byte real type
Date TypeDATE

Date type.
January 1, 4712 BC-December 31, 9999 AD

DATEDate Type 8byte
INTERVAL YEAR TO MONTH  Not supported
INTERVAL DAY TO SECOND  Not supported
TIMESTAMP WITH TIME ZONE  

Not supported

 

TIMESTAMP WITH LOCAL TIME ZONE  Not supported
TIMESTAMPThe precision of the second information can be expressed up to 9 digits.DATEExpress up to micro sec (6 digits)
  TIMESTAMPOption Type used in case of REPLICATION conflict
Binary TypeBFILELarge binary file type. Up to 4G Can be replaced with BLOB
 RAW (size)Primitive binary type. Up to 2000 bytes Can be replaced with BLOB
 LONG RAWVariable-length Winshi binary type. Up to 2G Use BLOB
   BYTE1 to 32000, fixed length binary data type
   NIBBLE1-254, variable length binary data type
   BIT

1~60576, consisting only of 0 and 1

Fixed-length binary data type

   VARBIT1 to 131068, variable length binary data type consisting only of 0s and 1s
Spatial Data Type  

 

GEOMETRY

 

Spatial data type up to 100M

API Comparison


FeatureOracleAltibaseRemark
SQLStandard SQL, transformed SQLStandard SQL, transformed SQL 
JDBC DriverProvidedProvided 
ODBC DriverProvidedProvided 
PHP DriverProvidedUse ODBC 
PDO DriverProvidedProvided 
Embedded SQLProvided (Pro*C/C++)Provided (APRE*C/C++) 
CLI InterfaceProvided (OCI)Provided (CLi) 
XA APIProvidedProvided 
Threaded ApplicationSupportedSupported 

Built-In Function


ClassificationOracleAltibaseDescription
Numeric Function

















ABSABSReturn absolute value
ACOSACOSReturn the arc cosine of n
ASINASINReturn the arc sine of n
ATANATANReturn the arctangent of n
ATAN2ATAN2Return the arc tangent of n/m
BITANDBITANDReturn an integer by performing AND operation on the bits of argument 1 and 2
BITNOTBITNOTReturn the result fo NOT operation for the bits of bit_a
BITORBITORReturn the result of OR operation for the bits of bit_a and bit_b
BITXORBITXORReturn the XOR (exclusive OR) operation result for the bits of bit_a and bit_b
CEILCEILRound up the number specified in the argument and return an integer
COSCOSReturn the cosine value
COSHCOSHReturn the hyperbolic cosine
EXPEXPReturn e to the power of n
FLOORFLOORReturn the maximum value among integers less than or equal to a specified number
Not supportedISNUMERICDetermine whether the entered formula is valid as a numeric data type
LNLNReturn the natural logarithm of the input
LOGLOGReturn the logarithm of n with the base m in LOG(m,n)
MODMODReturn the remainder of dividing n2 by n1
NANVLNot supportedIf the input value n2 is Nan (non-numeric), the replacement value n1 is returned. If n2 is not NaN, return n2
Not supportedNUMANDReturn the result of bitwise AND operation of BIGINT type bigint_a and bigint_a as BIGINT type result value
Not supportedNUMORReturn the result of bitwise OR operation of BIGINT type bigint_a and bigint_a as BIGINT type result value
Not supportedNUMSHIFTReturn the result of shifting as many as n bits to bigint, which is a BIGINT type, as a result value of BIGINT type
Not supportedNUMXORReturn the result of bitwise XOR operation of BIGINT type bigint_a and bigint_a as BIGINT type result value
POWERPOWERReturn the value of n2 to the power of n1
Not supportedRANDGenerate a random number between 0 and less than 1 and return it as a double type value
dbms.random()RANDOMReturn a pseudo-random integer value
REMAINDERMODReturn the remainder of n2 divided by n1
ROUND (number)ROUND (number)Return n value after the decimal point is rounded to integer
SIGNSIGNReturn the sign of n
SINSINReturn the sine of n
SINHSINHReturn the hyperbolic sine of n
SQRTSQRTReturn the square root of n
TANTANReturn the tangent of n
TANHTANHReturns the hyperbolic tangent of n
TRUNC (number)TRUNC (number)Truncate factor n1 to decimal place parameter n2 or less
WIDTH_BUCKETNot supportedCreate a histogram with the same area
Character functions that returns character values






















Not supportedCHOSUNGExtract and return only the first letter of each letter from the entered Hangul string
CHRCHRReturn the ASCII code corresponding to the decimal number n
CONCATCONCATConcatenate char1 and char2 and return
Not supportedDIGESTReturn the hash digest of expr as a VARCHAR type using a quasi-encrypted hash algorithm.
Not supportedDIGITSReturn input integer as a string
INITCAPINITCAPConvert the first letter of each word from the input string to uppercase and the rest to lowercase and return
LOWERLOWERConvert input string to lower case
LPADLPADFill expr1 from the specified digit n, and fill expr1 in the remaining space on the left
LTRIMLTRIMRemove all characters specified by set from the left side of the character string char
NCHRNCHRReturn Unicode character
NLS_INITCAPNot supportedReturn char by converting the first letter of each word to uppercase and the remaining letters to lowercase
NLS_LOWERNot supportedConvert all characters to lowercase and return
NLS_UPPERNot supportedReturn the input string converted to all uppercase letters
NLSSORTNot supportedSort input string and return string
Not supportedRANDOM_STRINGCreate an arbitrary string as long as the length in the format specified in the option
REGEXP_REPLACEREGEXP_REPLACEReplace the part that satisfies the specified regular expression with another specified string
REGEXP_SUBSTRREGEXP_SUBSTRReturn a substring that satisfies the specified regular expression
REPLACEREPLACEIn the first string given as a parameter, all the second strings are replaced with the third-string and the result is returned
Not supportedREPLICATEReturn a string repeated expr n times
Not supportedREVERSE_STRReturn the result of inverting the character order of expr
RPADRPADTo the right of the argument expr1, the character specified by the argument expr2 is repeated as long as n is necessary
RTRIMRTRIMRemove all characters specified by set from the right end of the argument char
Not supportedSIZEOFReturn the size of a string or the size allocated to it
SOUNDEXNot supportedReturn a string with the phonetic representation of char
Not supportedSTUFFRemove length from the position specified by start and return a string with expr2 inserted in that position
SUBSTR

SUBSTR

SUBSTRING

Return a string of length from the start character in expr
SUBSTRBSUBSTRBDetermine position and length in bytes, not characters
TRANSLATETRANSLATEEach character in from_string is replaced with the corresponding character in to_string and expr is returned
TREATNot supportedChange the declaration type of the argument
TRIPTRIMpRemove leading or trailing (both sides) characters from the string
UPPERUPPERConver all letters to uppercase
Character functions that return numeric valuesASCIIASCIIReturn the decimal value corresponding to the ASCII value of the first character of a given char
 Not supportedDATE_TO_UNIX

Convert expr of DATE type to a value in seconds based on 1970-01-01 00:00:00 (UTC +00:00 time zone) and return
Returns the decimal value corresponding to the ASCII value of the first character of

 INSTRINSTRReturn the position of the first occurrence of the specified character in a string as a number
 Not supportedINSTRBReturn the position of the specified string in bytes rather than characters
 LENGTH

CHAR_LENGTH

CHARACTER_LENGTH

LENGTH

Return the length of the argument char
 Not supportedLENGTHBReturn the length of the input string in bytes
 Not supportedOCT_TO_NUMConvert expr to octal
 Not supportedPKCS7PAD16Fit the total byte length of expr to a multiple of 16
 Not supportedPKCS7UNPAD16Restore a multiple of 16 byte string created using the KCS7PAD16() function to the data before padding
 Not supportedPOSITIONFind substring in input expr string and return the position of the first character of the substring
 REGEXP_COUNTREGENX_COUNTReturn the number of times the pattern is bright in a string
 REGEXP_INSTRREGEXP_INSTRReturn the first position (what character) of the part that satisfies the specified condition (regular expression)
NLS character function

NLS_CHARSET_DECL_LEN

NLS_CHARSET_ID

NLS_CHARSET_NAME

Not supportedReturn DB charset ID and name
Collation function

COLLATION

NLS_COLLATION_ID

NLS_COLLATION_NAME

Not supportedReturn information about collation settings
Datetime functionADD_MONTHSADD_MONTHSReturn the value of the date plus a specific number of months integer
Not supportedCONV_TIMEZONEConvert expr based on src_tz time zone to dest_tz time zone
CURRENT_DATECURRENT_DATEReturn the date information of the current session as Date data type
CURRENT_TIMESTAMPCURRENT_TIMESTAMPReturn the date and time information of the current session
+, - operation+, -, DATEADDReturn the result by increasing the date_field_name part of date by the number
Not supportedDATEDIFFReturn the value of enddate minus startdate (i.e. enddate-startdate) in the unit specified in date_field_name
Not supportedDATENAMEReturn the name of the month or weekday of the specified date according to the input date_field_name
DBTIMEZONEDB_TIMEZONEReturn the value of the database time zone
EXTRACT (datetime)

DATEPART

EXTRACT (datetime)

Return only the value corresponding to date_field_name in the input date
FROM_TZNot supportedConvert timestamp data type and time zone data type to TIMESTAMP WITH TIME ZONE data type
LAST_DAYLAST_DAYReturn the last day of the month in which the date belongs
LOCALTIMESTAMPNot supportedOutput the current date and time of timestamp
MONTHS_BETWEENMONTHS_BETWEENCalculate the month between date date1 and date2
NEW_TIMENot supportedOutput the Zone1 time in zone2 time
NEXT_DAYNEXT_DAYConvert the next date of the specified weekday based on that day
NUMTODSINTERVALNot supportedChange n to INTERVAL DAY TO SECOND character
NUMTOYMINTERVALNot supportedChange n to INTERVAL YEAR TO MONTH character
ORA_DST_AFFECTEDNot supported 
ORA_DST_CONVERTNot supported 
ORA_DST_ERRORNot supported 
ROUND (date)ROUND (date)Return the date rounded to the unit specified by the format model fmt
SESSIONTIMEZONESESSION_TIMEZONEReflect the time zone of the current session
SYS_EXTRACT_UTCNot supportedReturn Coordinated Universal Time—formerly Greenwich Mean Time (UTC)
SYSDATESYSDATEReturn the date and time of the OS where the database is located
SYSTIMESTAMPSYSTIMESTAMPReturn the system date
TRUNC (date)TRUNC (date)Round or cut dates based on year, month, and day
TZ_OFFSETNot supportedReturn the time zone offset corresponding to the argument based on the date the statement was executed
Not supportedUNIX_DATEOutput the current date and time of the operating system based on the UTC +00:00 time zone
Not supportedUNIX_TIMESTAMPOutput the current date and time of the operating system based on the UTC +00:00 time zone
Not supportedUNIX_TO_DATEConvert expr to DATE type and return
Comparison functionCASECASE, CASE2Convert expr to DATE type and return
GREATESTGREATESTReturn the largest value among one or more arguments
LEASTLEASTReturn the smallest value among the list of arguments EXPR
Conversion functionACSIISTRASCIISTRReturn the ASCII string of a string
 Not supportedBASE64_DECODEDecode the input string of VARBYTE type encoded in base64 format and return the original data of VARBYTE type
 Not supportedBASE64_DECODE_64VARBYTE type value is encoded in base64 format and VARBYTE type string is returned
 Not supportedBASE64_ENCODE_STRReturn the result of base64-encoded hexadecimal input string as a VARCHAR type string.
 Not supportedBINARY_LENGTHReturn the data length of binary data types such as BLOB, BYTE, and NIBBLE
 BIN_TO_NUMBIN_TO_NUMConvert bit (binary) vector to equivalent number (decimal)
 CASTCASTConvert data type or collection type to another data type or collection type
 CHARTOROWIDNot supportedConvert character type value to ROWID type
 COMPOSENot supportedReturn Unicode in normalized form
 CONVERTCONVERTConvert character set to another character set
 DECOMPOSENot supportedReturn the UNICODE string after decomposition into the same character set as the input
 Not supportedHEX_DECODEConvert hexadecimal string to ASCII string and return
 Not supportedHEX_ENCODEConvert ASCII string to hexadecimal string corresponding to each character and return
 Not supportedHEX_TO_NUMconvert expr to decimal
 HEXTORAWNot supportedConvert hexadecimal to raw value
 RAWTOHEXNot supportedConvert RAW to hexadecimal characters
 RAWTONHEXNot supportedConvert RAW TO NVARCHAR2 hexadecimal number
 Not supportedRAW_CONCATConcatenate and return values of multiple input VARBYTE data types that are not NULL
 Not supportedRAW_SIZEOFReturn the actual size of the data space allocated to the input expr
 Not supportedRAW_TO_FLOATConvert the value converted to VARBYTE data type to NUMERIC or FLOAT data type using TO_RAW function and return
 Not supportedRAW_TO_INTEGERReturn the value converted to VARBYTE as INTEGER data type by using TO_RAW function
 Not supportedRAW_TO_NUMERICConvert the value converted to VARBYTE data type to NUMERIC or FLOAT data type using TO_RAW function and return
 Not supportedRAW_TO_VARCHARConvert VARCHAR type data to VARCHAR type data converted VARBYTE type value using the TO_RAW function
 ROWIDTOCHARNot supportedConvert rowid value to VARCHAR2 format
 ROWIDTOONCHARNot supportedConvert rowid value to NVARCHAR2 format
 ROWNUMROWNUMOrder the value of a selected row, not supported in DML
 SCN_TO_TIMESTAMPNot supportedTake a number evaluated as a system change number (SCN) as an argument and return the nearest timestamp related to the SCN
 TIMESTAMP_TO_SCNNot supportedReturn system change number (SCN) related to timestamp
 Not supportedTO_BINConvert n to binary
 TO_BiNARY_DOUBLENot supportedReturn double-precision floating point
 TO_BINARY_FLOATNot supportedReturn a single-precision floating-point number
 TO_BLOB (bfile)Not supportedConvert BFILE to BLOB
 TO_BLOB (raw)Not supportedConvert RAW to BLOB
 TO_CHAR (bfile|blob)Not supportedConvert BFILE and BLOB to database charset
 TO_CHAR (character)Not supportedConvert to database character set
 TO_CHAR (datetime)TO_CHAR (datetime)Convert to VARCHAR data type value of specified format
 TO_CHAR (number)TO_CHAR (number)Convert to VARCHAR data type value
 TO_CLOB (bfile|blob)Not supportedConvert NCLOB value to CLOB value
 TO_CLOB (character)Not supportedConvert character value to CLOB
 TO_DATETO_DATEConvert char to date data type value
 TO_DSINTERVALNot supportedConvert INTERVAR DAY TO SECOND value
 Not supportedTO_HEXConvert n to hexadecimal
 Not supported

TO_INTERVAL

(NUMTODSINTERVAL)

Convert n to interval_unit unit and return
 TO_LOBNot supportedConvert LONG or LONG ROW value to LOB value
 TO_MULTI_BYTENot supportedReturn the character converted from a multibyte character to the corresponding single-byte character
 TO_NCHAR (character)TO_NCHAR (character)Convert to national character set
 TO_NCHAR (number)TO_NCHAR (number)Covert n to national character set
 TO_NCHAR (datetime)TO_NCHAR (datetime)Convert to national character set
 TO_NCLOBNot supportedConvert CLOB value to NCLOB value
 TO_NUMBERTO_NUMBERConvert expr to a value of data type NUMBER
 Not supportedTO_OCTConvert n to octal
 Not supportedTO_RAWConvert all data type values entered in n into VARBYTE type and return
 TO_SINGLE_BYTENot supportedConvert multibyte characters into corresponding single-byte characters and return char
 TO_TIMESTAMPTO_DATE

Convert char to value of TIMESTAMP data type

 TO_TIMESTAMP_TZNot supportedConvert char to TIMESTAMP WITH TIME ZONE data type
 TO_YMINTERVALNot supportedChange string to INTERVAL YEAR TO MONTH format
 TRANSLATE ... USINGNot supportedConvert char to the specified character set for conversion between the database character set and national character cents
 UNISTRUNISTRTake a text string as an argument and return it as a national language character set
 VALIDATE_CONVERSIONNot supportedDetermine whether expr can be converted to the specified data type
Large Object (LOB) functionBFILENAMENot supportedReturn the BFILE locator associated with the physical LOB binary file of the server file system
 EMPTY_BLOBEMPTY_BLOBInitialize lob variable and return the location of empty lob
 EMPTY_CLOBEMPTY_CLOBInitialize lob variable and return the location of empty lob
Collection functions related to nested tables

CARDINALITY

COLLECT

POWERMULTISET

POWERMULTISET_BY_CARDINALITY

SET

Not supportedFunctions related to nested tables
Hierarchical functionSYS_CONNECT_BY_PATHSYS_CONNECT_BY_PATHReturn the column value Path from root to node
Data mining functions

CLUSTER_DETAILS

CLUSTER_DISTANCE

CLUSTER_ID

CLUSTER_PROBABILITY

CLUSTER_SET

FEATURE_COMPARE

FEATURE_DETAILS

FEATURE_ID

FEATURE_SET

FEATURE_VALUE

ORA_DM_PARTITION_NAME

PREDICTION

PREDICTION_BOUNDS

PREDICTION_COST

PREDICTION_DETAILS

PREDICTION_PROABILITY

PREDICTION_SET

Not supportedData mining related functions
XML functions

APPRENDCHILDXML

DELETEXML

DEPTH

EXISTSNODE

EXTRACT (XML)

EXTRACTVALUE

INSERTCHILDXML

INSERTCHILDXMLAFTER

INSERTCHILDXMLBEFORE

INSERTXMLAFTER

INSERTXMLBEFORE

PATH

SYS_DBURIGEN

SYS_XMLAGG

SYS_XMLGEN

UPDATEXML

XMLAGG

XMLCAST

XMLCDATA

XMLCOLATTAVAL

XMLCOMMENT

XMLCONCAT

XMLDIFF

XMELEMENT

XMLEXISTS

XMLFOREST

XMLISVALID

XMLPARSE

XMLPATCH

XMLPI

XMLQUERY

XMLROOT

XMLSEQUENCE

XMLSERIALIZE

XMLTABLE

XMLTRANSFORM

 

Not supportedXML related functions
JSON functions

JSON_ARRAY

JSON_ARRAYAGG

JSON_DATAGUIDE

JSON_OBJECT

JSON_OBJECTAGG

JSON_QUERY

JSON_TABLE

JSON_VALUE

Not supportedJSON related functions
Encoding/Decoding functionsDECODEDECODESame as CASE WHEN where simple_case_expr is used
DUMPDUMPReturn the location and length of specified data in a specified format
ORA_HASHNot supportedCalculate a hash value for a given expression
STANDARD_HASHNot supportedCalculate standard hash value
VSIZEOCTET_LENGTHReturn the length of the input string in bytes
NULL functionsCOALESCECOALESCEReturns the first non-NULL argument
LNNVLLNNVLIf the result of the condition is FALSE or NULL, TRUE is returned, and if the condition is TRUE, FALSE is returned
NULLIFNULLIFIf expr1 and expr2 is the same, return NULL value
NVLNVLReplace NULL values with blanks in the query result
NVL2NVL2If expr1 is not NULL, NVL2 returns expr2. If it is NULL, expr3 is returned.
Environment and identifier functionsNot supportedHOST_NAMEReturn the name of the currently connected host

CON_DBID_TO_ID

CON_GUID_TO_ID

CON_NAME_TO_ID

CON_UID_TO_ID

ORA_INVOKING_USER

ORA_INVOKING_USERID

Not supported 
Not supportedSENDMSGSend message to ip=address, port as Socket datagram
SYS_CONTEXTSYS_CONTEXTReturn the result value of related parameters using the environment information (context) connected to the current session as a namespace
SYS_GUIDSYS_GUID_STR

Create and return a globally unique identifier (RAW value) consisting of 16 bytes.

Create a globally unique identifier of 16 bytes and returns it as a 32 hexadecimal string

SYS_TYPEIDNot supportedReturn the typeid of the identifier
UIDUSER_IDReturn an integer that uniquely identifies the session user
USERUSER_NAMEReturn the name of the session user
USERENVSESSION_ID

USERENV returns information about the session.

SESSION_ID returns the user's SESSION_ID

Approxiamtion functions

APPROX_COUNT_DISTINCT

APPROX_COUNT_DISTINCT_AGG

APPROX_COUNT_DISTINCT_DETAIL

APPROX_MEDIAN

APPROX_PERCENTILE

APPROX_PERCENTILE_AGG

APPROX_PERCENTILE_DETAIL

Not supported 
 GROUP_IDNot supportedDistinguish duplicate groups from the specified GROUP BY result
 GROUPINGGROUPING

When a column described in the GROUPING function is grouped by using it with the ROLLUP or CUBE operator.

In other words, a function that shows whether it was used in ROLLUP or CUBE operation.

 GROUPING_IDGROUPING_IDReturn the number corresponding to the GROUPING bit vector associated with the row
 MEDIANNot supportedReturns the median or interpolated value after sorting of values
 STAT_BINOMIAL_TESTNot supportedAn exact probability test used for dichotomous variables where only two valid values exist (variables with two exclusive values)
 STATS_CROSSTABNot supportedAnalyze two nominal variables
 STATS_F_TESTNot supported

Test whether there is a significant difference between the two variances

 STATS_KS_TESTNot supportedThe Kolmogorov-Smirnov function that tests whether two samples belong to the same population or that they belong to a population with the same distribution
 STATS_MODENot supportedReturn the value with the largest frequency
 STATS_MW_TESTNot supportedA Mann-Whitney test compares two independent samples.
 STATS_ONE_WAY_ANOVASTATS_ONE_WAY_ANOVAThe one-way analysis of variance function (STATS_ONE_WAY_ANOVA) verifies the significant difference in the mean (for a group or variable) for statistical significance by comparing two other estimates of variance
 STAT_T_TEST_(STATS_T_TEST_ONE, STAT_T_TEST_PAIRED, STATS_T_TEST_INDEP and STATS_T_TEST_INDEPU)Not supportedIn t-test, the significance of the difference between the mean values is measured
 STATS_WSR_TESTNot supportedWilcox sign ranking test of paired pairs is performed, and the difference between samples is tested whether there is a significant difference from zero
 SYS_OP_ZONE_IDNot supportedTake a rowid as an argument and return the area ID
 TO_APPROX_COUNT_DISTINCTNot supported 
 TO_APPROX_PERCENTILENOt supported 
Analysis functionsFIRST_VALUEFIRST_VALUEReturn the first value in an ordered set of values
Not supportedFIRST_VALUE_IGNORE_NULLSGet the value of the first row excluding null values
LAGLAGRefer to the previous value relative to the current row
Not supportedLAG_IGNORE_NULLS

Calculate the value of the first non-NULL row from the offset th after the current row

NTH_VALUENTH_VALUEFind the value of the offset th row
Not supportedNTH_VALUE_IGNORE_NULLSFind the value of the offset th row excluding null values
NTILENTILEDivide the output result by the number of groups specified by the user and output it
RATIO_TO_REPORTRATIO_TO_REPORTCalculate the ratio of a value to the sum of a set of values
ROW_NUMBERROW_NUMBERGive a ranking for the results sorted by division
Aggregation/analysis functionAVGAVGReturn the average of the rows that satisfy the conditions for the specified column, excluding nulls
 CORRCORRReturn the correlation coefficient for a pair of numbers
 CORR_ (CORR_S, CORR_K)Not supported(See CORR) Calculate Pearson's correlation coefficient
 COUNTCOUNTReturn the number of rows returned by the query
 COVAR_POPCOVAR_POPReturn the population covariance of a set of number combinations
 COVAR_SAMPCOVAR_SAMPReturn the sample covariance of a set of number pairs
 CUME_DISTCUME_DISTCompute the cumulative distribution of values in a group of values
 DENSE_RANKDENSE_RANKRank is given to the column or expression used in the ORDER BY clause. Unlike RANK(), the rank after the same rank returns a value that is increased by 1 regardless of the number of the same rank.
 FIRSTFIRSTOperate on a set of values from a set of rows by ranking as FIRST or LAST for a given sort specification
 Not supportedGROUP_CONCATReturn the string concatenated with non-NULL expr1 in each group
 LASTLASTThe last row is extracted by sequencing the rows
 LISTAGGLISTAGGReturn a single string by concatenating a string and a separator for all rows in a group
 MAXMAXReturn the maximum value among arguments
 MINMINReturn the minimum value among arguments
 PERCENT_RANKPERCENT_RANKReturn the rank percentage of a value for the number of groups
 PERCENTILE_CONTPERCENTILE_CONTInverse distribution function assuming a continuous distribution model
 PERCENTILE_DISKPERCENTILE_DISCInverse distribution function assuming a discrete distribution model
 RANKRANKCalculate the rank of values in a group of values
 REGR_ (Linear Regression) FunctionsNot supportedThe linear regression function fits a normal least squares regression line to a set of numeric pairs
 STDDEVSTDDEVReturn the sample standard deviation of expr, which is a combination of numbers
 STDDEV_POPSTDDEV_POPCalculate the population standard deviation and return the square root of the population variance
 STDDEV_SAMPSTDDEV_SAMPCalculate the cumulative sample standard deviation and returns the square root of the sample variance
 SUMSUMReturn the sum of the values of expr
 VAR_POPVAR_POPReturn the population variance of a set of Numbers after removing null values
 VAR_SAMPVAR_SAMPReturn the sampling variance of a set of numbers after removing nulls.
 VARIANCEVARIANCEReturn the variance of expr
Object reference functions

DEREF

MAKE_REF

REF

REFTOHEX

VALUE

Not supportedObject reference functions
Model functions

CV

ITERATION_NUMBER

PRESENTNNV

PRESENTV

PREVIOUS

Not supportedAvailable only in Model_clause of Select statement
OLAP functionCUBE_TABLENot supportedConvert 3D data to 2D data
Data cartridge function

DATAOBJ_TO_MAT_PARTITION

DATAOBJ_TO_PARTITION

Not supportedUseful for data cartridge development
EncryptionDBMS_CRYPTO

AESDECRYPT

AESENCRYPT

DESDECRYPT

DESENCRYPT

TDESDECRYPT

TRIPLE_DESDECRYPT

TDESENCRYPT

TRIPLE_DESENCRYPT