Q&A BY TAG '#SQL'

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

Hi there, I'm trying to convert a field of data type 'text' to 'integer' in denodo. The below is my sample operation. select column1, column2, column3 from bv_sample order by cast(field1 as integer) ; I get the below error: "Error converting data t...

#Denodo #denodotestingtool #testingtool #denodo #SQL #VQL

I want to stripe-off special character when i query the column. is there a special funtion to do this. e.g. i have characters like ~ @ in the data. so if have value@like, i want to select valuelike. if i have panda~, i want to select panda.

#SQL #VQL

do you have some examples of how can i setvar and use the getvar in VQL?

#sql