[indo-oracle] oracle multiple insert

[Hanafi]

HI Indo-oracle,
Selain cara berikut di bawah ini:

If you wanted to insert 3 rows into the suppliers table, you could run the
following SQL statement:

    INSERT ALL
       INTO suppliers (supplier_id, supplier_name) VALUES (1000, 'IBM')
       INTO suppliers (supplier_id, supplier_name) VALUES (2000,
'Microsoft')
       INTO suppliers (supplier_id, supplier_name) VALUES (3000, 'Google')
    SELECT * FROM dual;

http://www.techonthenet.com/oracle/questions/insert_rows.php

Apakah ada cara lain untuk multiple insert di oracle?

dan kenapa harus ada select statement ya?

Thanks.

Hanafi.


[Non-text portions of this message have been removed]