This shows you the differences between two versions of the page.
kurs:version_table [2014/09/10 21:22] |
kurs:version_table [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | select * from ( | ||
+ | select first_name, | ||
+ | last_name, | ||
+ | salary, | ||
+ | nvl(versions_starttime, to_date( '1', 'YYYY')) as start_time, | ||
+ | nvl(versions_endtime, sysdate) as end_time | ||
+ | from accountants versions between scn minvalue and maxvalue | ||
+ | ) | ||
+ | where | ||
+ | start_time < to_date('20071119-2000', 'YYYYMMDD-hh24mi') | ||
+ | order by start_time | ||
+ | </code> |