Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Updating Multiple Tables using FORALL option in ORACLE

Tags:

oracle-database

for-loop

plsql

database-performance

oracle11g

Could any one help me how to give multiple DML statements inside FORALL option in oracle.

like image 505
Kishore Kanumalla Avatar asked Nov 23 '25 21:11

Kishore Kanumalla

1 Answers

how to give multiple DML statements inside FORALL

You cannot. One FORALL statement can support only one DML statement. For "n" DMLs, you need to write "n" FORALL statements.

like image 144
Lalit Kumar B Avatar answered Nov 27 '25 00:11

Lalit Kumar B
Sign in to Comment

Related questions

SQL: partition over two columns
scalar subquery in if statement Condition in PL/SQL
Migrating an Oracle database with a C# application attached to it: How to manage database migration?
error OPENing an OUT SYS_REFCURSOR with FOR UPDATE SKIP LOCKED
Oracle - Get statistics of a query
What SQL Parameter Type to use for an IN condition when using MappingSqlQuery
How do I set the window title for a SQL*Plus (Windows) instance?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!