commit command

[Romeo Ranjan]

Hi ALL,

I have a question regarding the oracle sql commit command. After executing a set of 20 truncate command.

example:

TRUNCATE TABLE NAME;
TRUNCATE TABLE SALARY;
TRUNCATE TABLE ACCOUNT;
COMMIT;

I finally gave the command COMMIT. Will the commit command will work of all the truncate command or only for the last truncate command,

TRUNCATE TABLE ACCOUNT;

.

Thanks.

[Tom Reilly]

I'm pretty sure once you issue a truncate, your data is gone. It doesn't wait for a commit. From this web page,

DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.

Therefore commit is useless here.