CODEWITHSUNDEEP
sqlplsqloracle-sqldeveloper
Vishal Afre
Vishal Afre

Reputation: 1043

Execute Oracle SQL command after PL/SQL block

I've an SQL file which has some PL/SQL scripts and some DML scripts, but I'm not able to run normal DML commands just after a PL/SQL block IN SQL Developer. For e.g.

BEGIN
    -- Some Statements
END;

UPDATE TABLE TABLE_NAME SET FLD_NAME = SOMETHING;

Do I need to change anything here so that I can run these commands.

PS: I don't want to put everything in BEGIN ... END block.

Upvotes: 2

Views: 1564

Answers (1)

ASz
ASz

Reputation: 119

try put / after anonymous block:

BEGIN
    -- Some Statements
END;
/

UPDATE TABLE TABLE_NAME SET FLD_NAME = SOMETHING;

Upvotes: 4

Related Questions