# 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 indicator can be used with the BLOB and NCLOB data types depending on the engine. For more information on Simple indicators, see [Simple](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/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 indicator can be used with the BINARY\_DOUBLE and BINARY\_FLOAT data types. For more information on Simple indicators, see [Simple](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/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 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 indicators, see [Simple](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/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 |