Discussion Board for collaboration on QlikView Scripting.
I got a script like this.
Connect to database (Oracle)
Select * from dual;
drop table TEST;
My question is how qlikview differentiates the drop table statement is a qlikview one but not a oracle statement .
Thanks in advance for all your replies
Go to Solution.
You can think of an implicite SQL before your SELECT (SQL in front of SELECT is optional, both versions are valid syntax). So you have two SQL statements, both ended with a semi-colon.
Good question ;-)
The SQL statement string ends with the semi-colon ';'
Only the contents of the SQL statement get passed to the DB server (ie up to the ; ), so the drop table is executed by QV, not the DB.
Hope that helps
But i tried like this and it gave me the explain plan. So does that mean qilkview ends the DB script immediately after first occuring SELECT statement ?
explain plan for Select * from dual;
select * from table(dbms_xplan.display);
Up to the semicolon. You would need two SQL statements to send two queries.
Thank you. But it gave me with single SQL statement .Thats were i got confused.
Thank you swuehl. I never knew that. That answers my question.