https://wiki.ispirer.com/ 2026-04-14T07:43:15+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/string-functions/ascii?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - ASCII Function Oracle - ASCII Syntax ASCII() Description ASCII function returns decimal representation of the first character according to ASCII code set Equivalents in Other Databases Database Equivalent SQL Server ASCII text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/chr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - CHR Function Oracle - CHR Syntax CHR() Description CHR function returns character with the binary equivalent of a number specified Equivalents in Other Databases Database Equivalent SQL Server CHAR text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/concat?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - CONCAT Function Oracle - CONCAT Syntax CONCAT() Description CONCAT function returns concatenated string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/initcap?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - INITCAP Function Oracle - INITCAP Syntax INITCAP() Description INITCAP function returns string with the first letter of each word in uppercase text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/instr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - INSTR Function Oracle - INSTR Syntax INSTR() Description INSTR function returns position of a string in the string Equivalents in Other Databases Database Equivalent SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/instr2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - INSTR2 Function Oracle - INSTR2 Syntax INSTR2() Description INSTR2 function returns position of a string in the string Equivalents in Other Databases Database Equivalent SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/instr4?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - INSTR4 Function Oracle - INSTR4 Syntax INSTR4() Description INSTR4 function returns position of a string in the string Equivalents in Other Databases Database Equivalent SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/instrb?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - INSTRB Function Oracle - INSTRB Syntax INSTRB() Description INSTRB function returns position of a string in the string Equivalents in Other Databases Database Equivalent SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/instrc?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - INSTRC Function Oracle - INSTRC Syntax INSTRC() Description INSTRC function returns position of a string in the string Equivalents in Other Databases Database Equivalent SQL Server CHARINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LENGTH Function Oracle - LENGTH Syntax LENGTH() Description LENGTH function returns length of a string Equivalents in Other Databases Database Equivalent SQL Server LEN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/length2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LENGTH2 Function Oracle - LENGTH2 Syntax LENGTH2() Description LENGTH2 function returns length of a string Equivalents in Other Databases Database Equivalent SQL Server LEN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/length4?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LENGTH4 Function Oracle - LENGTH4 Syntax LENGTH4() Description LENGTH4 function returns length of a string Equivalents in Other Databases Database Equivalent SQL Server LEN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/lengthb?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LENGTHB Function Oracle - LENGTHB Syntax LENGTHB() Description LENGTHB function returns length of a string Equivalents in Other Databases Database Equivalent SQL Server LEN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/lengthc?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LENGTHC Function Oracle - LENGTHC Syntax LENGTHC() Description LENGTHC function returns length of a string Equivalents in Other Databases Database Equivalent SQL Server LEN text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/lower?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LOWER Function Oracle - LOWER Syntax LOWER() Description LOWER function returns string with each letter in lowercase Equivalents in Other Databases Database Equivalent SQL Server LOWER text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/lpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LPAD Function Oracle - LPAD Syntax LPAD() Description LPAD function returns left-padded string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/ltrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - LTRIM Function Oracle - LTRIM Syntax LTRIM() Description LTRIM function returns string with removed spaces from the left end Equivalents in Other Databases Database Equivalent SQL Server LTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/nchr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - NCHR Function Oracle - NCHR Syntax NCHR() Description NCHR function returns character with the binary equivalent to number in national character set specified Equivalents in Other Databases Database Equivalent SQL Server NCHAR text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/nls-initcap?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - NLS_INITCAP Function Oracle - NLS_INITCAP Syntax NLS_INITCAP() Description NLS_INITCAP function returns string with the first letter of each word in uppercase using the special linguistic requirements of case conversions text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/nls-lower?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - NLS_LOWER Function Oracle - NLS_LOWER Syntax NLS_LOWER() Description NLS_LOWER function returns string with each letter in lowercase using the special linguistic requirements of case conversions text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/nls-upper?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - NLS_UPPER Function Oracle - NLS_UPPER Syntax NLS_UPPER() Description NLS_UPPER function returns string with each letter in uppercase using the special linguistic requirements of case conversions text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/nlssort?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - NLSSORT Function Oracle - NLSSORT Syntax NLSSORT() Description NLSSORT function returns string of bytes used to sort the value text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/regexp-count?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - REGEXP_COUNT Function Oracle - REGEXP_COUNT Syntax REGEXP_COUNT() Description REGEXP_COUNT function returns number of times the pattern occurs in string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/regexp-instr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - REGEXP_INSTR Function Oracle - REGEXP_INSTR Syntax REGEXP_INSTR() Description REGEXP_INSTR function returns position of a pattern in the string Equivalents in Other Databases Database Equivalent SQL Server PATINDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/regexp-replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - REGEXP_REPLACE Function Oracle - REGEXP_REPLACE Syntax REGEXP_REPLACE() Description REGEXP_REPLACE function returns string with the replaced occurences of the specified pattern text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/regexp-substr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - REGEXP_SUBSTR Function Oracle - REGEXP_SUBSTR Syntax REGEXP_SUBSTR() Description REGEXP_SUBSTR function returns extract from string matching the pattern specified text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - REPLACE Function Oracle - REPLACE Syntax REPLACE() Description REPLACE function returns string with the replaced occurences of the specified string Equivalents in Other Databases Database Equivalent SQL Server REPLACE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/rpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - RPAD Function Oracle - RPAD Syntax RPAD() Description RPAD function returns right-padded string text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/rtrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - RTRIM Function Oracle - RTRIM Syntax RTRIM() Description RTRIM function returns string with removed spaces from the right end Equivalents in Other Databases Database Equivalent SQL Server RTRIM text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/soundex?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - SOUNDEX Function Oracle - SOUNDEX Syntax SOUNDEX() Description SOUNDEX function returns phonetic representation of a string Equivalents in Other Databases Database Equivalent SQL Server SOUNDEX text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/substr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - SUBSTR Function Oracle - SUBSTR Syntax SUBSTR() Description SUBSTR function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent SQL Server SUBSTRING text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/substr2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - SUBSTR2 Function Oracle - SUBSTR2 Syntax SUBSTR2() Description SUBSTR2 function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent SQL Server SUBSTRING text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/substr4?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - SUBSTR4 Function Oracle - SUBSTR4 Syntax SUBSTR4() Description SUBSTR4 function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent SQL Server SUBSTRING text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/substrb?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - SUBSTRB Function Oracle - SUBSTRB Syntax SUBSTRB() Description SUBSTRB function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent SQL Server SUBSTRING text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/substrc?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - SUBSTRC Function Oracle - SUBSTRC Syntax SUBSTRC() Description SUBSTRC function returns extract from string beginning at character position specified Equivalents in Other Databases Database Equivalent SQL Server SUBSTRING text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/translate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - TRANSLATE Function Oracle - TRANSLATE Syntax TRANSLATE() Description TRANSLATE function returns string with replaced occurrences of each character specified to its corresponding character specified text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/treat?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - TREAT Function Oracle - TREAT Syntax TREAT() Description TREAT function returns expression of the data type specified text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/trim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - TRIM Function Oracle - TRIM Syntax TRIM() Description TRIM function returns string with removed spaces from the left and/or from the right end text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions/string-functions/upper?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - UPPER Function Oracle - UPPER Syntax UPPER() Description UPPER function returns string with each letter in uppercase Equivalents in Other Databases Database Equivalent SQL Server UPPER