How can I execute custom SQL commands using ORACLE SQLLDR

Question

I have SQL statements as follows:

INSERT INTO PERSON(PERSON_ID, YEAR_OF_BIRTH) VALUES (1, 0);
UPDATE PERSON SET PERSON_ID=2;

How can I execute such type of SQL commands contained successively in a single file? I need to execute this SQL file in the Java code.

Thanks.

Sajan Chandran · Accepted Answer · 2013-09-09 12:12:40Z

1

Construct an sql statement with both the queries (INSERT and UPDATE) using PreparedStatement and executes executeBatch which is according to the documentation Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts like

preparedStatement.executeBatch();

answered Sep 9, 2013 at 12:12

Sajan Chandran

11.5k3 gold badges34 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

How can I execute custom SQL commands using ORACLE SQLLDR

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related