SELECT TEST FROM REGISTRE WHERE ID_REGISTRE = 1256
-TEST is CLOB but I want to display the text that is inside with a SQL query in Oracle
The query works but it displays (HUGECLOB).
Asked
Active
Viewed 34 times
0
-
Does this https://stackoverflow.com/questions/3790379/how-to-query-a-clob-column-in-oracle answer your question? – d r Jan 24 '23 at 06:21
-
The query doesn't *display* anything, it returns the data that client software need to process. You need to setup the tool you use to fetch clob data for display (generally it is three dots or a double click in an IDE) – astentx Jan 24 '23 at 06:51