![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
iCode0410
这个作者很懒,什么都没留下…
展开
-
Oracle NLS_DATE_FORMAT
nls_date_format用于修改日期格式 session级别的修改:alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'windows平台下修改注册表: HKEY_LOCAL_MACHINE.SOFTWARE.ORACLE.HOME0 新建字符串值NLS_DATE_FORMAT ,并设置其值为:YYYY-MM-DD:原创 2014-09-23 15:49:38 · 1546 阅读 · 0 评论 -
Oracle —— before row trigger OR after row trigger
before trigger可以修改new valuebefore trigger可以提前中止,而不需要回滚statement[]: AFTER row triggers are slightly more efficient than BEFORE row triggers. With BEFORE row triggers, affected data blocks must be r原创 2014-10-21 19:46:23 · 919 阅读 · 0 评论