Your database has a table customers that contains the columns cust_name, amt_due, and old_status.
Examine the commands executed and their output:
SQL>UPDATEcustomersSETamt_due=amt_due+amt_due*l. 1WHEREcust_name='JAMES';
1row updated.
SQL> ALTER TABLE customers DROP COLUMN old_status;
Table Altered
SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_r.ame='JAMES';
1 row updated.
SQL> COMMIT;
SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN,
versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION', amt_due FROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE
custname='JAMES';.
XIDSTART_SCNEND_SCNOPERATIONAMT_DUE
-------------------------- ----------------------- ------------------- ------------------- ------------------------
07002f00cl03000017063371706337 U3300
Why is it that only one update is listed by the Flashback Version Query?