Database Reference
In-Depth Information
1 row updated.
SQL> commit;
Commit complete.
SQL> update employees
set salary=salary*1.05
where employee_id = 193;
1 row updated.
SQL> commit;
Commit complete.
SQL> update employees
set salary=salary/2
where employee_id=193;
1 row updated.
SQL> commit;
Commit complete.
As you can see, our sample employee received a 3 percent raise, a 5 percent raise, and
then had his salary cut in half. Next, we will query the table using the VERSIONS BETWEEN
clause to view the history of changes:
SQL> select salary
from employees
versions between scn minvalue and maxvalue
where employee_id = 193;
SALARY
----------
2108.93
4217.85
4017
3900
Search WWH ::




Custom Search