tag:blogger.com,1999:blog-7395977411859619892.post6320985622602000612..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: Check constraints with sysdateRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7395977411859619892.post-46511764619405280592012-12-05T18:17:00.561+01:002012-12-05T18:17:00.561+01:00What happens when someone tries to create an index...What happens when someone tries to create an index on the virtual column?Stew Ashtonhttps://www.blogger.com/profile/10004507258457241890noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-13957578866563416692011-03-14T21:10:42.557+01:002011-03-14T21:10:42.557+01:00If you are in the same session, then yes, the dete...If you are in the same session, then yes, the deterministic clause will cache the result the first time and produce the same result the second time.Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-55649456728579739622011-03-07T21:48:47.340+01:002011-03-07T21:48:47.340+01:00What happens when someone's insert fails becau...What happens when someone's insert fails because the date is in the future (let's say by one minute), and then two minutes later they try again when the date is no longer in the future. Couldn't the previous DETERMINISTIC call prevent the now-valid (no longer in future) date from being allowed since Oracle could remember the value from the prior execution?Ryanhttps://www.blogger.com/profile/01933879578495746805noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-89048854742978119372010-10-28T14:44:57.496+02:002010-10-28T14:44:57.496+02:00great solution!great solution!Anonymoushttps://www.blogger.com/profile/00042732832902083596noreply@blogger.com