tag:blogger.com,1999:blog-4818542164384221282.post2889458243596468633..comments2024-02-12T19:54:33.009+08:00Comments on Grassroots Oracle: One more COALESCE vs NVL example to finish the week...Scott Wesleyhttp://www.blogger.com/profile/18106937181788036683noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4818542164384221282.post-43088318108813752552010-02-15T10:17:47.589+08:002010-02-15T10:17:47.589+08:00Quite true, particularly of Forms environments.
A...Quite true, particularly of Forms environments.<br /><br />Another possibility (in Forms) is utilising something like this within a common function.<br /><br />TO_DATE(NAME_IN('system.current_datetime'), 'DD-MON-YYYY HH24:MI:SS')Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-4818542164384221282.post-120666123831110012010-02-14T04:45:59.623+08:002010-02-14T04:45:59.623+08:00Better still, if you are going to using USER a lot...Better still, if you are going to using USER a lot in PL/SQL, copy it to a package level constant (eg g_user) and use that.<br /><br />Once I even saved a bunch of time by only hitting SYSDATE one and using DBMS_UTILITY.GET_TIME to keep the global variable up-to-date.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.com