<div>
What tool do you or your DBA use to execute the script ?
</div>


What tool do you or your DBA use to execute the script ?

<div>
I execute the script in Oracle SQL Developer V 3.1.07
</div>


I execute the script in Oracle SQL Developer V 3.1.07

<div>
Hello flow01,<br />
<br />
Figured it out.<br />
I clicked the green triangle icon (Run Statement).<br />
But I should have been clicking the icon next to the Run Statement<br />
icon which is the Run Script (looks like a piece of paper with a green triangle).<br />
<br />
This made both statements run.<br />
<br />
Thanks.
</div>


Hello flow01,

Figured it out.
I clicked the green triangle icon (Run Statement).
But I should have been clicking the icon next to the Run Statement
icon which is the Run Script (looks like a piece of paper with a green triangle).

This made both statements run.

Thanks.

<div>
<div class="content wysiwyg-content">
Hello expert,<br />
<br />
I need to go to the DBA with a script to delete rows in two tables.<br />
<br />
Wrote<br />
<br />
DELETE FROM J3131_ACP_D_NOTE_SEGMENT <br />
where NOTE_ID = 798105 and SEGMENT_ID in (2359467, 2359468, 2359469);<br />
<br />
DELETE FROM J3131_ACP_D_NOTE_SEGMENT_M<wbr />KT<br />
where NOTE_ID = 798105 and SEGMENT_ID in (2359467, 2359468, 2359469);<br />
<br />
COMMIT;<br />
<br />
But it only executes the first statement<br />
<br />
Have tried running the two statements in separate queries with positive<br />
result. But when combined only the first goes.<br />
<br />
Was told by the DB expert that the semicolon is needed after <br />
the first statement, Is he wrong?<br />
<br />
Thanks.<br />
<br />
Allen in Dallas
</div>
</div>


Hello expert,

I need to go to the DBA with a script to delete rows in two tables.

Wrote

DELETE FROM J3131_ACP_D_NOTE_SEGMENT 
where NOTE_ID = 798105 and SEGMENT_ID in (2359467, 2359468, 2359469);

DELETE FROM J3131_ACP_D_NOTE_SEGMENT_MKT
where NOTE_ID = 798105 and SEGMENT_ID in (2359467, 2359468, 2359469);

COMMIT;

But it only executes the first statement

Have tried running the two statements in separate queries with positive
result. But when combined only the first goes.

Was told by the DB expert that the semicolon is needed after 
the first statement, Is he wrong?

Thanks.

Allen in Dallas

PL/SQL Two statements

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.