随笔分类 -  Oracle Excellent Article

摘要：网址：http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:1270688200346183091异常的处理：http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:1270688200346183091It is interesting to note that Oracle considers PL/SQL anonymous blocks to be statements as well. Consider the fo 阅读全文

摘要：网址：http://www.databasedesign-resource.com/oracle-log-files.html 阅读全文

摘要：网址:http://cuddletech.com/articles/oracle/node58.html http://cuddletech.com/articles/index.shtml参考网址:http://blog.csdn.net/tianlesoftware/article/details/4693470 http://blog.csdn.net/tianlesoftware/article/details/5674309 启用归档日至模式Enabling ARCHIVELOG Mode Most of the High Availability features... 阅读全文

摘要：Oracle中NULL的用法:参考网址:http://www.oratechinfo.co.uk/nulls.html#null_defUsing NULLsDefinition of NULLUsing NULL in a mathematical expression always returns NULLAppending NULL to a non-null string does not affect the stringAggregate functions tend to "ignore" NULLsGROUP BY treats NULL as a sepe 阅读全文

摘要：SESSION 阅读全文

摘要：Lock:参考如下网址:http://broadh2o.net/docs/database/oracle/oracleLocks.html http://docs.oracle.com/cd/E11882_01/server.112/e10592/ap_locks001.htm#SQLRF55502 (Automatic Locks in DML Operations) http://docs.oracle.com/cd/E11882_01/server.112/e25789/consist.htm#CNCPT1339(数据库的事务和读一致性和O... 阅读全文

摘要：Collections and Records 阅读全文

摘要：Block StructureThe basic units (procedures, functions, and anonymous blocks) that make up aPL/SQL program are logical blocks, which can be nested inside one another.A block groups related declarations and statements. You can place declarations close towhere they are used, even inside a large subprog 阅读全文

摘要：http://orafaq.com/node/854ORACLE锁: Oracle uses locks to control concurrent access to data. A lock gives you temporary ownership of a database resource such as a table or row of data. Thus, data cannot be changed by other users until you finish with it. You need never explicitly lock a resource becau 阅读全文

摘要：本文参考网址:http://psoug.org/reference/with.html http://www.oracle-base.com/articles/misc/with-clause.php http://gennick.com/with.html------Understanding the WITH Claus 参考文档下载地址:http://ishare.iask.sina.com.cn/f/21674385.html The WITH query_name clause lets you assign a nam... 阅读全文

摘要：本文转载自:http://bbs.chinaunix.net/thread-1820702-1-1.html如果有侵犯版权方面的问题，本人将立即删除:1.尝试在google,论坛，metalink,online document里搜索。2.写清楚你的执行log,报错信息，写清楚DB version , OS 3.Instance 方面的问题，请贴出alertlog 4.网络问题，贴出server 的listener.ora , sqlnet.ora 运行lsnrctl status , 贴出client 的 tnsnames.ora , sqlnet.ora ,运行tnsping 5.DB总体 阅读全文