Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add option to exectue mutlitple commands #436

Closed
dnlw07 opened this issue Nov 4, 2019 · 2 comments
Closed

Add option to exectue mutlitple commands #436

dnlw07 opened this issue Nov 4, 2019 · 2 comments
Labels

Comments

@dnlw07
Copy link

dnlw07 commented Nov 4, 2019

Is your feature request related to a problem? Please describe.
Extension does not allow to execute multiple INSERT scripts at once.

Describe the solution you'd like
Please add an option to execute all scripts in file or only selected ones.

@dnlw07 dnlw07 added the feature request New issue opened using "Feature request" template label Nov 4, 2019
@mtxr
Copy link
Owner

mtxr commented Nov 4, 2019

this is already supported.

just tested with this query.

The only problem is the messages not being displayed.

INSERT INTO "test_db"."public"."department" (id, dept, emp_id) VALUES (1, 'first item', 1);
INSERT INTO "test_db"."public"."department" (id, dept, emp_id) VALUES (2, 'second item', 2);
INSERT INTO "test_db"."public"."department" (id, dept, emp_id) VALUES (3, 'third item', 3), (4, 'fourth item', 4);

SELECT * from department;

Peek 2019-11-04 14-54

@mtxr mtxr closed this as completed Nov 4, 2019
@mtxr mtxr added invalid and removed feature request New issue opened using "Feature request" template labels Nov 4, 2019
@dnlw07
Copy link
Author

dnlw07 commented May 29, 2020

Hello,
could you please reopen the issue again?
I have noticed that multiple selection is working fine for SQLite, however for Oracle it is still problematic.

The query I am trying to execute:

select '1' AS COST_CENTER_CODE, 'HCPERM' AS SKF_NAME from dual;
select '2' AS COST_CENTER_CODE, 'EHPERM' AS SKF_NAME from dual;

The error I receive:
ORA-00933: SQL command not properly ended

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants