Posts

Showing posts with the label insert

Commit After Insert Oracle

Image
Commit After Insert Oracle . Insert into table (col2) values (val2); /* now, a database trigger is expected to be invoked which makes an insertion into table2 */. Oracle COMMIT How Does COMMIT Work in Oracle? from www.educba.com Insert into t1 values ( 2,6); Alter function , create function and drop function also cause an implicit commit when used with stored functions, but not with loadable functions. The commit statement releases all row and table locks, and erases any savepoints you marked since the last commit or rollback.