oracle查询基础5.pptVIP

* * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. [Title of the course] You can use the VERSIONS BETWEEN clause to retrieve all of the versions of the rows that exist or have ever existed between the time the query was issued and a point back in time. If the undo retention time is smaller than the lower bound time/SCN of the BETWEEN clause, then the query retrieves versions up to the undo retention time only. The time interval of the BETWEEN clause can be specified as an SCN interval, or a wall clock interval. This time interval is closed at both the lower and the upper bound. In the example, Lorentz’s salary changes are retrieved. The NULL value for the END_DATE for the first version indicates that this was the existing version at the time of the query. The NULL for the START_DATE for the last version indicates that this version was created at a time before the undo retention time. * * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. [Title of the course] * * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. [Title of the course] Use the For more slide to provide learners with suggestions on how to continue learning about the subject of this course. Add or remove elements as needed. If you add additional elements, such as images or text, remember to give each element a Fade or some other animation effect. Also consider referring learners to job-aids, online discussion forums, blogs, knowledge bases, help desks, Webinars, and other sources of knowledge. To make links open referenced Web sites: Select the text you want as a link. Select Insert ? Hyperlink or type Ctrl-K. Enter the Web address in the Address field. Click OK. * * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. [Title of the course] * * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. [Title of the course] * * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. [Title of the course] You can