Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need clarification on qlikview drop table statement

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

7 Replies
swuehl
MVP
MVP

Good question 😉

The SQL statement string ends with the semi-colon ';'

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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;

jonathandienst
Partner - Champion III
Partner - Champion III

Up to the semicolon. You would need two SQL statements to send two queries.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Hello Jonathan,

Thank you. But it gave me with single SQL statement .Thats were i got confused.

swuehl
MVP
MVP

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.

Not applicable
Author

Thank you swuehl. I never knew that. That answers my question.