topic Oracle SQL Query help? in QlikView

Oracle SQL Query help?

Tue, 02 Jun 2015 18:48:54 GMT

I've spent a while coming up with a query for an Oracle dB, but QLikview doesn't seem to accept it at all. I'm quite sure it's not T-SQL and am fairly sure I conformed to ANSI but still QV isn't having it. Attached is a test app with the load script, any suggestions would be helpful!

Re: Oracle SQL Query help?

ronald_gdi — Tue, 02 Jun 2015 18:56:08 GMT

Hi David

In script Qlikview only interpreted commands SQL of driver.

Use:

Load *

SQL <your_code_sql>;

<your_code_sql> must have query sql

Kind Regards!

Re: Oracle SQL Query help?

maxgro — Tue, 02 Jun 2015 19:08:21 GMT

as your query isn't a trivial one, use a different tool (sqlplus, sql developer, toad, etc....) to test the query on an oracle database; when the syntax of the query is ok, add the query to QlkiView script (usually a correct query run without any problem in QlikView load script but debugging and testing the query is easier in an external and ad hoc tool)