A CONTAINED IN query will return rows that were valid only within a specified period. Rows with valid-time periods that may start within the specified period, but continue beyond the period are not returned.
SELECT * FROM employee_vt FOR VALIDTIME CONTAINED IN (DATE’2004-01-01’,DATE’2005-12-31’);
Output:
eid ename terms job_start job_end ---- ----- ----- ---------- ----------- 1005 Alice TW11 2004/12/01 2005/12/01 1003 SRK TM02 2004/02/10 2005/02/09