https://wiki.ispirer.com/ 2026-04-15T08:23:06+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/asciistr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - ASCIISTR Function Oracle - ASCIISTR Syntax ASCIISTR() Description ASCIISTR takes as its argument a string, or an expression that resolves to a string, in any character set and returns an ASCII version of the string in the database character set. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/bin-to-num?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - BIN_TO_NUM Function Oracle - BIN_TO_NUM Syntax BIN_TO_NUM() Description BIN_TO_NUM converts a bit vector to its equivalent number. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/cast?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - CAST Function Oracle - CAST Syntax CAST() Description CAST converts one built-in datatype or collection-typed value into another built-in datatype or collection-typed value. Equivalents in Other Databases Database Equivalent HiRDB text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/chartorowid?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - CHARTOROWID Function Oracle - CHARTOROWID Syntax CHARTOROWID() Description CHARTOROWID converts a value from CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to ROWID datatype. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/compose?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - COMPOSE Function Oracle - COMPOSE Syntax COMPOSE() Description COMPOSE returns a Unicode string in the same character set as the input. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/convert?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - CONVERT Function Oracle - CONVERT Syntax CONVERT() Description CONVERT converts a character string from one character set to another. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/decode?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - DECODE Function Oracle - DECODE Syntax DECODE() Description DECODE compares specified expression to each search value one by one. If expression is equal to a search value, then Oracle Database returns the corresponding result. If no match is found, then Oracle returns default. If default is omitted, then Oracle returns null. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/conversion-functions/decompose?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - DECOMPOSE Function Oracle - DECOMPOSE Syntax DECOMPOSE() Description DECOMPOSE takes as its argument a string in any datatype and returns a Unicode string after decomposition in the same character set as the input.