Execute dynamic sql and pl/sql in Java via web interface

Question

Currently I'm making sort of SQL command line interface for web-based application. It should act roughly like sqlPlus. I have encountered a problem how to execute sql's. They can be both as SQL and/or PL/SQL.

First way I thought that I can split them (by ';' or ';/') and detect separately if it's sql select or delete/update/insert or pl/sql.

Now I cant find for PL/SQL Backus–Naur Form to make regexp. May be there exists easier way?

Generally, What is the best way to make such logic ?

TIA

FerranB · Accepted Answer · 2010-02-16 12:56:57Z

2

I think the best way is to use ANTLR which have a PLSQL grammar. You can generate code for java and other languages.

edited Feb 16, 2010 at 12:56

answered Feb 16, 2010 at 11:49

FerranB

37k18 gold badges70 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

James Wang · Accepted Answer · 2012-01-08 09:53:37Z

0

Use regexp to separate SQL statement and PLSQL in a sql script is almost impossible.

declare
begin
select sysdate from dual;

dbms.output('hello');
end;
/

Do you have any ideas how to recognize such a simple PLSQL code using regexp. A SQL Parser is what you need to achieve this, here is an article that may helpful.

answered Jan 8, 2012 at 9:53

James Wang

4814 silver badges5 bronze badges

Collectives™ on Stack Overflow

Execute dynamic sql and pl/sql in Java via web interface

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related