Q&A BY TAG '#SQL'

You must sign in to ask a question. If you do not have an account, you can register here

How to convert rows to columns using SPLIT function/any generic function in Denodo
answered 06-11-2020 04:45:33 -0500

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...

Answers: 1

#Denodo #Split #SQL #rowsToColumns

Converting the text data type into an integer data type
answered 14-09-2020 08:50:46 -0400

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...

Answers: 3

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

Special character
answered 09-03-2017 07:24:02 -0500

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.

Answers: 1

#SQL #VQL

GETVAR,SETVAR examples needed
answered 05-12-2016 11:34:02 -0500

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

Answers: 1

#sql