Latest Activity


Extract certain data from a text column

There is a text column in denodo but It's JSONB datatype in datasourse. Here is my query: Can JSONB/JSON datatype in denodo even though I am using JDBC connection to Postgres. If the 1st scenario is not possible how can i split the text column in...

#extract #Split


How to convert rows to columns using SPLIT function/any generic function in Denodo

Hi Team, I need to know is there any generic function available in DENODO for SPLIT function which can be used for any of the views without depending on one single view/function. Example: In Oracle we do have below function which can be used in any o...

#Denodo #Split #SQL #rowsToColumns