Equivalent of Oracle's CLOB in Databricks

[VCA50380]

Dear all,

(migrating for an on-premise Oracle ...)

The question is in the subject: "What is the equivalent of Oracle's CLOB in Databricks" ?
I saw that the "string" type can go up to 50 thousands characters, which is quite good in most of our cases, but this would not cover all.
Also, I don't need this only as data-type for a column in a table, but currently in Oracle we are also concatenating or "aggregating" texts into some CLOB for a usage in a procedure / function, etc... What would be the paths to do the same in Databricks ?

Thanks!
Vinc

[Alberto_Umana]

Hi @VCA50380,

For concatenating or aggregating texts similar to how you use CLOBs in Oracle procedures or functions, you can use the concat function in Databricks. Here is an example of how you can concatenate strings:

SELECT concat(string1, string2, string3) AS concatenated_string
FROM your_table;

[VCA50380]

Hello;
Thanks for the answer.
For the concatenation itself, it is not an issue.
My question is "is Databricks supporting something bigger than the 'string' data-type" ? 
Thanks

[VCA50380 · Accepted solution]

Hello,
Gemini gave me some answers. I'll investigate from there.

Thanks