Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I got a script like this.
Connect to database (Oracle)
TEST :
SQL
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
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 ';'
Hi
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
Jonathan
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 ?
Connect to database (Oracle)
TEST :
SQL
explain plan for Select * from dual;
select * from table(dbms_xplan.display);
drop table TEST;
Up to the semicolon. You would need two SQL statements to send two queries.
Hello Jonathan,
Thank you. But it gave me with single SQL statement .Thats were i got confused.
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.
Thank you swuehl. I never knew that. That answers my question.