Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Clob selection in Data model

Received Response
55
Views
3
Comments
Rank 1 - Community Starter

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):

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 1 - Community Starter

    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.

  • Rank 1 - Community Starter

    I am facing the same issue. Need the full value of Clob column and remove the HTML tags.

  • Rank 8 - Analytics Strategist

    @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

Welcome!

It looks like you're new here. Sign in or register to get started.