代码改变世界

随笔档案-2011年5月24日

Asktom：Sending HTML using UTL_SMTP

2011-05-24 17:15 by Tracy., 466 阅读, 收藏,
摘要： Hi TomI hope I'm phrasing this correctly...I'd like to be able to send an HTML formatted email from the database using the UTL_SMTP package. I don't see any way of setting the MIME type.Is this beyond... 阅读全文

ITPUB: HAVING COUNT 的妙用

2011-05-24 16:06 by Tracy., 439 阅读, 收藏,
摘要： 帮忙分析一个sql -- Create table CREATE TABLE TMP_TB ( TID VARCHAR2(10) NOT NULL, ORDID VARCHAR2(10), STATUS VARCHAR2(10) ); -- Create/Recreate primary, unique and foreign key constraints ALTER TABLE TMP_TB... 阅读全文

Using Oracle 10g Tuning Utilities

2011-05-24 12:34 by Tracy., 284 阅读, 收藏,
摘要： Oracle is always improving life for DBAs and developers with each release of the RDBMS. 10g has many new features to help troubleshoot and tune the database. Starting with 10g, Oracle has introduced ... 阅读全文

Introduction to Oracle 10g's New SQL Tuning Advisor

2011-05-24 12:12 by Tracy., 284 阅读, 收藏,
摘要： Continuation of Tuning Task The first suggestion given by the tuning advisor was to gather statistics on the two structures that we are joining as it can only produce valid analysis and suggestions i... 阅读全文