I tested this on Oracle 11.2. If you update a table in SQL*Plus then update it again with a different value in a PL/SQL block, the second update replaces the first:
SQL> create table tab1 as
2 select 1 col1 from dual
SQL> update tab1 set col1 = 2
1 row updated.
I saw that the SYSTEM tablespace in an Oracle 11.2 database was getting quite big so I checked the size of SYS.AUD$:
C:\Users\AJ0294094>sqlplus / as sysdba
SQL*Plus: Release 22.214.171.124.0 Production on Fri May 16 13:20:54 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
In this example, I want to show that Oracle does not execute an AFTER DELETE trigger after doing a TRUNCATE. I tested it on Oracle 11.2. First I created a table:
SQL> create table tab1 (my_name varchar2(10))
Then I inserted a row into it:
SQL> insert into tab1 values ('Andrew')
1 row created.
SQL> select * (more...)
I noticed this in an Oracle 188.8.131.52.0 database. DBMS_STATS failed with an ORA-00600 and the first argument was . On investigation, it seemed to have something to do with the fact that the table had a function based index:
SQL> SELECT COUNT(*) FROM DBA_INDEXES