# Oracle data types

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

Depending on the engine you are using, SQL or Java, some data types may not be supported.

For more information about Oracle data types, see [Data types](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Types.html#GUID-A3C0D836-BADB-44E5-A5D4-265BA5968483).

The [Oracle-Supplied types](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Types.html#GUID-B3300D21-4598-4AE5-AA95-451E9F1040ED) are not supported with both engines:

* [Any types](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Types.html#GUID-5A8C5AC6-BC32-4D78-B0DE-037162106C72)
* [XML types](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Types.html#GUID-BF935A5E-3E6C-42C0-AA18-05D3A268D7D8)
* [Spatial types](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Types.html#GUID-B4DF3B59-1600-4FA2-B7ED-AF7B734256BF)

Some indicators may not work with some data types. For more information, see the tables below:

* BLOB and NCLOB data types.
* CLOB data type.
* Binary data types: BINARY\_DOUBLE, BINARY\_FLOAT.
* Other data types: BFILE, RAW, LONG RAW, ROWID, UROWID.

## BLOB and NCLOB data types

The following table describes if a simple statistics indicator can be used with the BLOB and NCLOB data types depending on the engine. For more information on simple statistics indicators, see [Simple statistics](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-01/simple-statistics).

| Indicators | BLOB (SQL and Java) | NCLOB (SQL) | NCLOB (Java) |
| --- | --- | --- | --- |
| Row count | Yes | Yes | Yes |
| Null count | Yes | Yes | Yes |
| Distinct count | No | No | Yes |
| Unique Count | No | No | Yes |
| Duplicate Count | No | No | Yes |
| Blank Count | Not applicable | Not applicable | Not applicable |
| Default Value Count | Not applicable | No | Not applicable |

## CLOB data type

Information noteImportant: When using an SQL engine, the CLOB data type is not supported on some indicators that use the DISTINCT, UNIQUE, GROUP BY, and ORDER BY clauses. You can use a Java engine instead.

The following table describes if an indicator can be used with the CLOB data type depending on the engine.

| Indicators | CLOB (SQL) | CLOB (Java) |
| --- | --- | --- |
| Row count | Yes | Yes |
| Null count | Yes | Yes |
| Distinct count | No | Yes |
| Unique Count | No | Yes |
| Duplicate Count | No | Yes |
| Blank Count | No | Yes |
| Default Value Count | No | No |
| Minimal Length | Yes | Yes |
| Minimal Length with Null | Yes | Yes |
| Minimal Length with Blank | Yes | Yes |
| Minimal Length with Blank and Null | Yes | Yes |
| Maximal Length | Yes | Yes |
| Maximal Length with Null | Yes | Yes |
| Maximal Length with Blank | Yes | Yes |
| Maximal Length with Blank and Null | Yes | Yes |
| Average Length | No | Yes |
| Average Length with Null | Yes | Yes |
| Average Length with Blank | Yes | Yes |
| Average Length with Blank and Null | Yes | Yes |
| Mean | Not applicable | Not applicable |
| Median | Not applicable | Not applicable |
| Lower Quartile | Not applicable | Not applicable |
| Upper Quartile | Not applicable | Not applicable |
| Minimum | Not applicable | Not applicable |
| Maximum | Not applicable | Not applicable |
| Mode | No | Yes |
| Value Frequency | No | Yes |
| Value Low Frequency | No | Yes |
| Pattern Frequency | No | Yes |
| Pattern Low Frequency | No | Yes |
| Soundex Frequency | No | Yes |
| Soundex Low Frequency | No | Yes |
| Benford Law | No | Yes |
| Column Set Analysis | No | Yes |
| Regex pattern | Yes | Yes |

## Binary data types

The following table describes if a simple statistics indicator can be used with the BINARY\_DOUBLE and BINARY\_FLOAT data types. For more information on simple statistics indicators, see [Simple statistics](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-01/simple-statistics).

| Indicators | BINARY\_DOUBLE (SQL) | BINARY\_DOUBLE (Java) | BINARY\_FLOAT (SQL) | BINARY\_FLOAT (Java) |
| --- | --- | --- | --- | --- |
| Row count | Yes | Yes | Yes | Yes |
| Null count | Yes | Yes | Yes | Yes |
| Distinct count | Yes | Yes | Yes | Yes |
| Unique Count | Yes | Yes | Yes | Yes |
| Duplicate Count | Yes | Yes | Yes | Yes |
| Blank Count | Not applicable | Not applicable | Not applicable | Not applicable |
| Default Value Count | Yes | No | Yes | No |

## Other data types

The following table describes if a simple statistics indicator can be used with the BFILE, RAW, LONG RAW, ROWID, and UROWID data types with both engines, SQL and Java. For more information on simple statistics indicators, see [Simple statistics](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-01/simple-statistics).

| Indicators | BFILE | RAW | LONG RAW | ROWID | UROWID |
| --- | --- | --- | --- | --- | --- |
| Row count | Yes | Yes | Yes | Yes | Yes |
| Null Count | Yes | Yes | Yes | Yes | Yes |
| Distinct count | No | Yes | No | Yes | No |
| Unique Count | No | Yes | No | Yes | Yes |
| Duplicate Count | No | Yes | No | Yes | No |
| Blank Count | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable |
| Default Value Count | Not applicable | Not applicable | Not applicable | Not applicable | Not applicable |