• 博客访问: 96917
  • 博文数量: 47
  • 用 户 组: 普通用户
  • 注册时间: 2013-11-23 01:02





发布时间:2005-04-25 11:09:10

You Asked (Jump to Tom's latest followup)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 the scope of UTL_SMTP?thanks in advance!Ken and we said...I asked Tyler Muth (tyler.muth@oracle.com) to answer this one since I knew he already had the code (we use it on our Oracle Calendar software shipped with the email server to send reminde......【阅读全文】

阅读(6854) | 评论(0) | 转发(0)

发布时间:2005-04-22 12:50:11

Mohammad -- Thanks for the question regarding "list all user(s) group by group_list", version 8.1.7originally submitted on 27-Jun-2003 10:46 Eastern US time, last updated 21-Apr-2005 12:02 Tom's latest followup | GOTO a Bookmarkable Page | BottomYou Asked (Jump to Tom's latest followup)Hello Tom,i have the follwing table:LOGIN_NAME GROUP_LIST--------------- --------------------------------------------------Demo 1; 9000; 1000;Koo 1000;Feh ......【阅读全文】

阅读(2306) | 评论(0) | 转发(0)

发布时间:2005-04-22 12:00:24

很多人都会为如何创建索引发愁, 在什么情况下需要创建索引? 对哪些字段创建索引? 创建什么索引?下面就是对应的答案, 来自Oracle perf tunning guide.Choosing Columns and Expressions to Index A key is a column or expression on which you can build an index. Follow these guidelines for choosing keys to index: Consider indexing keys that are used frequently in WHERE clauses.Consider indexing keys that are used frequently to join tables in SQL statements. For more information on optimizing joins......【阅读全文】

阅读(1535) | 评论(0) | 转发(0)

发布时间:2005-04-21 08:37:35

Building a Random Character Value Generator Oracle Database 10g provides a random value generator via a package named DBMS_RANDOM, which can be used to generate random values. However, those values are arbitrary, not representative of the real-life system. For instance, the following an example of how you can generate a string 30 characters ......【阅读全文】

阅读(1960) | 评论(0) | 转发(0)

发布时间:2005-04-21 02:55:51

create or replace procedure who_called_me( owner out varchar2, name out varchar2, lineno out number, caller_t out varchar2 )as call_stack varchar2(4096) default dbms_utility.format_call_stack; n number; found_stack BOOLEAN default FALSE; line varchar2(255); cnt number := 0;begin-- loop n := instr( call_stack, chr(10) ); exit when ( cnt = 3 or n is NUL......【阅读全文】

阅读(1156) | 评论(0) | 转发(0)

jametong2014-06-27 16:58


回复  |  举报

登录 注册