https://wiki.ispirer.com/ 2026-04-28T01:20:31+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/data-types/bfile?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - BFILE Versions: Oracle 11g, 10g, 9i and 8i Oracle - BFILE Syntax BFILE Data Pointer to a binary file that are stored in file systems outside Oracle Database. BFILE column stores a BFILE locator - the directory and the file name text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/binary_double?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - BINARY_DOUBLE Versions: Oracle 11g and 10g Oracle - BINARY_DOUBLE Syntax BINARY_DOUBLE Data 64-bit, double-precision floating-point number Range 1.79769313486231E+308 to 2.22507485850720E-308 Special Values Supports special values INF, -INF (Infinity) and NaN (Not a number) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/binary_float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - BINARY_FLOAT Versions: Oracle 11g and 10g Oracle - BINARY_FLOAT Syntax BINARY_FLOAT Data 32-bit, single-precision floating-point number Range 3.40282E+38F to 1.17549E-38F Special Values Supports special values INF, -INF (Infinity) and NaN (Not a number) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/blob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - BLOB Versions: Oracle 11g, 10g, 9i and 8i Oracle - BLOB Syntax BLOB Data Variable-length binary data (binary large object) Range 4G Transactions BLOB objects have full transactional support, any changes can be committed or rolled back text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/char?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - CHAR Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - CHAR Syntax CHAR[(n [CHAR | BYTE])] Data Fixed-length character data, single-byte and multibyte character sets Parameters n is the maximum number of bytes if BYTE is specified (default, defined by NLS_LENGTH_SEMANTICS) or characters if CHAR is specified, optional text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/clob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - CLOB Versions: Oracle 11g, 10g, 9i and 8i Oracle - CLOB Syntax CLOB Data Variable-length character data (character large object), single-byte and multibyte character sets Range 4G Character Set Database default text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - DATE Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - DATE Syntax DATE Data Date and time data (year, month, day, hours, minutes and seconds) Range January 1, 4712 BC 00:00:00 to December 31, 9999 23:59:59 Standards text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - FLOAT Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - FLOAT Syntax FLOAT[(p)] Data Floating-point numeric data Parameters p is the binary precision. 126 digits of binary precision is roughly equivalent to 38 digits of decimal precision text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/interval_day_to_second?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - INTERVAL DAY TO SECOND Versions: Oracle 11g, 10g and 9i Oracle - INTERVAL DAY TO SECOND Syntax INTERVAL DAY [(p1)] TO SECOND [(p2)] Data Stores a period of time in days, hours, minutes, seconds and fractional seconds text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/interval_year_to_month?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - INTERVAL YEAR TO MONTH Versions: Oracle 11g, 10g and 9i Oracle - INTERVAL YEAR TO MONTH Syntax INTERVAL YEAR [(p)] TO MONTH Data Stores a period of time represented as years and months Range 0 <= p <= 9 Defaults p is 2 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/long_raw?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - LONG RAW Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - LONG RAW Syntax LONG RAW Data Variable-length binary data Range 2G Notes Oracle strongly recommends to use BLOB data type instead of LONG RAW as it has far fewer restrictions than LONG RAW text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/long?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - LONG Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - LONG Syntax LONG Data Variable-length character data Range 2G Notes LONG columns are supported only for backward compatibility, they are not recommended for use. A table can contain only one LONG column text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/nchar?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - NCHAR Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - NCHAR Syntax NCHAR[(n)] Data Fixed-length character data in Unicode - UTF-8 or UTF-16 Parameters n is the maximum number of characters, optional Range 1 <= text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/nclob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - NCLOB Versions: Oracle 11g, 10g, 9i and 8i Oracle - NCLOB Syntax NCLOB Data Variable-length character data (character large object) in Unicode - UTF-8 or UTF-16 Range 4G Transactions BLOB objects have full transactional support, any changes can be committed or rolled back text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/number?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - NUMBER Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - NUMBER Syntax NUMBER[(p[,s])] Data Integer, decimal and floating-point numeric data Parameters p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/nvarchar2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - NVARCHAR2 Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - NVARCHAR2 Syntax NVARCHAR2(n) Data Variable-length character data in Unicode - UTF-8 or UTF-16 Parameters n is the maximum number of characters Range 1 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/raw?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - RAW Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - RAW Syntax RAW(p) Data Variable-length binary data Range 1 ⇐ p ⇐ 2000 Defaults You must specify the size for RAW columns Standards Oracle Extension Oracle RAW - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/rowid?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - ROWID Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - ROWID Syntax ROWID Data Physical row address for heap-organized (regular) tables returned by rowid pseudocolumn Standards Oracle Extension Related Data Types in Oracle text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/timestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - TIMESTAMP Versions: Oracle 11g, 10g and 9i Oracle - TIMESTAMP Syntax TIMESTAMP[(p)] [WITH [LOCAL] TIME ZONE] Data Date and time data (year, month, day, hours, minutes, seconds and fractional seconds) WITH TIME ZONE means that Oracle stores time zone offset text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/urowid?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - UROWID Versions: Oracle 11g, 10g and 9i Oracle - UROWID Syntax UROWID [(p)] Data Logical row address for index-organized or foreign tables. Index-orginized tables store data in index leaves which can move. Foreign tables are external tables, for example in IBM DB2 database text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/data-types/varchar2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Data Types - VARCHAR2 Versions: Oracle 11g, 10g, 9i, 8i and 7.3 Oracle - VARCHAR2 Syntax VARCHAR2(n [CHAR | BYTE]) Data Variable-length character data, single-byte and multibyte character sets Parameters n is the maximum number of bytes if BYTE is specified (default, defined by NLS_LENGTH_SEMANTICS) or characters if CHAR is specified