https://wiki.ispirer.com/ 2026-04-30T16:27:26+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/conversions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Database Conversions * to HiRDB * to Greenplum text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - Data Types Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Data Type Parameters and Range Character Data Types CHAR(n) - Fixed-length character data 1 <= n <= 2000/charsize, default is 1 NCHAR(n) - Fixed-length character data in Unicode 1 <= n <= text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/date-time-functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - Date and Time Functions This article describes the date and time functions in Oracle. Overview Date and Time Function Description SYSDATE Returns the current date and time TRUNC(Date) Truncates date to the specified part SYSDATE Oracle - SYSDATE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/expressions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - Expressions This article describes identifiers in Oracle 11g and earlier. Overview Expression Description DECODE() Compares expressions to each search value and returns the corresponding result. DECODE Oracle - DECODE Syntax DECODE(expr, search, result {, search, result} [, default]) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Functions * SQL Functions Mapping to Other Databases * Numeric Functions * ABS * ACOS * ASIN * ATAN * ATAN2 * BITAND * CEIL * COS * COSH * EXP * FLOOR * LN * LOG * MOD * NANVL * POWER * REMAINDER * ROUND (number) * SIGN * SIN * SINH * SQRT * TAN * TANH * TRUNC (number) * String Functions * ASCII * CHR * … text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/identifiers?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - Identifiers This article describes identifiers in Oracle. Identifiers rules Oracle - Identifier First Character An alphabetical character Subsequent Characters Alphanumeric characters, the underscore (_), dollar sign ($), and pound sign (#) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/migration-assessment?rev=1741078744&do=diff User Documentation Ispirer Assessment Tools Overview Pricing Oracle Migration Assessment * Collecting Information text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/plsql-collections?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle PL/SQL Collections PL/SQL data types TABLE and VARRAY allow you to define collections, an ordered set of elements, all of the same type. Each element is addressed by a unique index. You can define collection types in a procedure, function, or package. You can pass collection variables as parameters to PL/SQL subprograms. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/plsql-records?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing PL/SQL Records PL/SQL record is a group of fields, each with own name and data type, similar to the columns in a table row. You can use a record variable to store a table row, or some columns from a table row. The %ROWTYPE attribute lets you declare a PL/SQL record that represents a row in a table, without listing all the columns. You can also declare a cursor to select specific columns, and then apply %ROWTYPE to the cursor. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/string-functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - String Functions This article describes string functions in Oracle. Overview String Function Description LENGTH() Length of string SUBSTR() Substring at the specified position and length INSTR() Position of substring in string LENGTH Oracle - LENGTH text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/system-functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - System Functions Overview Function Description NVL() Replaces NULL value with specified value NVL Oracle - NVL Syntax NVL(expr1, expr2) Description If expr1 is NULL, the function returns expr2. If expr1 is not NULL, the function returns text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/table-definition?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Table Definition * Default Column Value text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/techniques?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Techniques General * Returning Result Sets from Stored Procedures Miscellaneous * BLOB and CLOB Comparison * Return Application Name text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/to-hirdb?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Conversions from Oracle to HiRDB * Functions text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/transactions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle - Transactions This article describes transactions in Oracle 11g and earlier. Transactions In Oracle, transactions are implicit as defined by the ANSI standard. This means that a transaction is automatically initiated after connection, COMMIT or ROLLBACK statements.