摘要: Doc ID 461911.1 Patch 6602742 Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.3 and later Information in this document applies to an 阅读全文
posted @ 2016-04-08 15:56 guilingyang 阅读(662) 评论(0) 推荐(0) 编辑
摘要: 1 COALESCE 語法:COALESCE(expr1, expr2, ..., exprn) n>=2 作用:COALESCE returns the first non-null expr in the expression list. You must specify at leasttwo 阅读全文
posted @ 2016-04-08 15:35 guilingyang 阅读(212) 评论(0) 推荐(0) 编辑
摘要: 我這oracle版本為11.2.0.4,裝的GRID,所以在grid用戶下編輯sqlnet.ora 1.cd /grid/product/11.2.0/network/admin 2.編輯sqlnet.ora #开启ip限制功能tcp.validnode_checking=yes#允许访问数据库的I 阅读全文
posted @ 2016-04-08 14:38 guilingyang 阅读(211) 评论(0) 推荐(0) 编辑