Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Clob selection in Data model

Summary:
Selecting CLOB column in data model SQL
Content (required):
Team,
I want to fetch a clob column completely in a report using data model SQL. I tried using DBMS_LOB and this does not give data more than 4000. Is there any other way to fetch full CLOB details in column ?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi @acmhari
Are you able to find on how to fetch CLOB column ?
I had the same issue now. If you were able to fetch it. Please let me know the steps It would be very helpful to me.
0 -
I am facing the same issue. Need the full value of Clob column and remove the HTML tags.
0 -
@SNG01 - This thread is quite old. Please create a new post in the community with all the details of your requirement. This will ensure it is noticed by more community users and you receive better responses to your query. Thank you
1