topic Oracle functions in QlikView

Oracle functions

Fri, 04 Mar 2011 06:31:36 GMT

Hi ,

Does the Script editor in Qlikview Supports all the Oracle functions.Or is there any limitations.

Oracle functions

Anonymous — Fri, 04 Mar 2011 07:30:26 GMT

The QlikView script itself doesn't care about what commands and functions you pass to your back end oracle DB. Everything that is enclosed in the SQL .......; part is sent to the driver as is. Then it's up to the DB connector to make sense of it and return a dataset.

So, basically Yes, you should be able to use any functions supported by your driver and DB, but it's not really QlikView doing anything special except passing the request along to the driver and returning the data (or potential error message from the driver if your syntax is incorrect for example).

Oracle functions

Mon, 07 Mar 2011 05:28:11 GMT

Hi Johannes,

Thanks for your response. The reason for this question is i was trying to execute the Lead and Lag functions but i was getting the error. I am not able to find the issue is from the oracle or driver passing the oracle commands.