且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Oracle 12c中使用时间有效性?

更新时间:2023-10-26 16:04:52

是的,您将能够更改12c中的表以启用时间有效性(请参见文档的ALTER TABLE部分:

Yes, you will be able to ALTER the table in 12c to enable Temporal Validity (see the ALTER TABLE section of the docs: http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_3001.htm#CJAEGCFI)

它通过将where子句转换为< =和">或为null"子句而起作用,因此,如果不需要,您无需更改固定日期.

It works by converting your where clause to a "<=" and "> or is null" clause, so you don't need to change the fixed dates if you don't want to.

汤姆·凯特(Tom Kyte)刚刚在他的博客上发布了有关此内容的文章,并列举了一些出色的例子: http://tkyte.blogspot.com /2013/07/12c-flashforward-flashback-or-see-it-as.html

Tom Kyte just posted on his blog about this today, with some execellent examples: http://tkyte.blogspot.com/2013/07/12c-flashforward-flashback-or-see-it-as.html