<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<!-- saved from url=(0062)http://searchdatabase.techtarget.com.cn/tips/489/2064989.shtml -->
<HTML lang=zh-CN xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>Oracle中Decode()函数使用技巧_TechTarget IT专家网</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META http-equiv=Content-Language content=zh-CN>
<META content="IT 专家网 | TechTarget中文站" name=author>
<META content="IT 专家网 | TechTarget中文站" name=Copyright>
<META content=定向,分众,整合,IT,专家; name=keywords><!--判断订阅新闻邮件地址合法性开始-->
<SCRIPT language=JavaScript>
function doZoom(size){
document.getElementById('zoom').style.fontSize=size+'px'
}
function datacheck() {
var op = newsletter.email.value;
//m = op.match(new RegExp("^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$"));
m = op.match(new RegExp("^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$"));
//客户ID(不能为空)
if (newsletter.email.value==""){
alert("邮件地址不能为空!");
newsletter.email.focus();
return false;
} else if(m == null) {
alert("邮件格式不正确!");
newsletter.email.focus();
return false;
}
else
return true;
}
</SCRIPT>
<!--判断订阅新闻邮件地址合法性结束--><!--定义及判断地显示广告、新闻邮件订阅、左侧文字链、一周排行榜等开始-->
<SCRIPT language=JavaScript>
var blcss
var cid
var siteid
var newsletters
var newslettername
var path = location.hostname;
var ename = "";
var wzlink
var leftjobjs = "http://www.techtarget.com.cn/ttfiles/toparticle/tt-content-leftjob.js";
var resourcejs
var jsurl = "http://images.chinabyte.com/techtarget/ad-pip/techtarget-pip.js";
var tlgg
var technet
var sqjh
var zizhanname
reg = /(\w+)\.(\w+)\.(\w+)\.(\w+)/;
if(reg.test(path)) {
reg.exec(path);
ename = RegExp.$1;
}
switch (ename) {
case "searchwebservices" :
blcss="/TLimages/css/tt-webservices-content.css"
cid = "504"
siteid = 12
newsletters = 121
newslettername = "SearchWebservices电子新闻邮件"
forumid = 142
jsurl ="http://images.chinabyte.com/techtarget/ad-pip/tt-webservices-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-webservices-tlgg-news.js"
technet ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-technet1.js"
sqjh = "http://searchwebservices.techtarget.com.cn/TT_CLUB_ARTICLE/searchwebservices_article.js"
zizhanname ="Web服务子站"
break
case "searchwin2000" :
blcss="/TLimages/css/tt-win2000-content.css"
cid = "491"
siteid = 2
newsletters = 21
newslettername = "SearchWin2000电子新闻邮件"
forumid = 142
resourcejs ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-content-resource.js"
jsurl ="http://images.chinabyte.com/techtarget/ad-pip/tt-winsystems-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-winsystems-tlgg-news.js"
technet ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-technet1.js"
sqjh = "http://searchwinsystem.techtarget.com.cn/TT_CLUB_ARTICLE/searchwin2000_article.js"
zizhanname ="WinSystem 子站"
break
case "searchwinsystem" :
blcss="/TLimages/css/tt-win2000-content.css"
cid = "491"
siteid = 2
newsletters = 21
newslettername = "SearchWinSystem电子新闻邮件"
forumid = 142
resourcejs ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-content-resource.js"
jsurl ="http://images.chinabyte.com/techtarget/ad-pip/tt-winsystems-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-winsystems-tlgg-news.js"
technet ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-technet1.js"
sqjh = "http://searchwinsystem.techtarget.com.cn/TT_CLUB_ARTICLE/searchwin2000_article.js"
zizhanname ="WinSystem子站"
break
case "searchdatabase" :
blcss="/TLimages/css/tt-database-content.css"
cid = "392"
siteid = 3
newsletters = 31
newslettername = "SearchDatabase电子新闻邮件"
forumid = 154
jsurl ="http://images.chinabyte.com/techtarget/ad-pip/tt-database-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-database-tlgg-news.js"
sqjh = "http://searchdatabase.techtarget.com.cn/TT_CLUB_ARTICLE/searchdatabase_article.js"
zizhanname ="数据库子站"
break
case "searchmobilecomputing" :
blcss="/TLimages/css/tt-mobile-content.css"
cid = "513"
siteid = 4
newsletters = 41
newslettername = "SearchMobileComputing电子新闻邮件"
forumid = 1012
jsurl ="http://images.chinabyte.com/techtarget/ad-pip/tt-mobilecomputing-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-mobilecomputing-tlgg-news.js"
sqjh = "http://searchmobilecomputing.techtarget.com.cn/TT_CLUB_ARTICLE/searchmobilecomputing_article.js"
zizhanname ="移动计算子站"
break
case "searchsecurity" :
blcss="/TLimages/css/tt-security-content.css"
cid = "502"
siteid = 5
newsletters = 51
newslettername = "SearchSecurity电子新闻邮件"
forumid = 140
wzlink = "http://www.techtarget.com.cn/ttfiles/toparticle/tt_sn_wzlink.js"
resourcejs ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-content-resource.js"
jsurl = "http://images.chinabyte.com/techtarget/ad-pip/tt-security-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-security-tlgg-news.js"
technet ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-technet.js"
sqjh = "http://www.techtarget.com.cn/TT_CLUB_ARTICLE/searchsecurity_article.js"
zizhanname ="安全子站"
break
case "searchcio" :
blcss="/TLimages/css/tt-cio-content.css"
cid = "508"
siteid = 6
newsletters = 61
newslettername = "SearchCIO电子新闻邮件"
forumid = 1044
resourcejs ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-content-resource.js"
jsurl ="http://images.chinabyte.com/techtarget/ad-pip/tt-cio-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-cio-tlgg-news.js"
sqjh = "http://searchwindowssecurity.techtarget.com.cn/TT_CLUB_ARTICLE/searchcio_article.js"
zizhanname ="CIO子站"
break
case "searchstorage" :
blcss="/TLimages/css/tt-storage-content.css"
cid = "503"
siteid = 7
newsletters = 71
newslettername = "SearchStorage电子新闻邮件"
forumid = 1039
jsurl = "http://images.chinabyte.com/techtarget/ad-pip/tt-storage-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-storage-tlgg-news.js"
sqjh = "http://searchstorage.techtarget.com.cn/TT_CLUB_ARTICLE/searchstorage_article.js"
zizhanname ="存储子站"
break
case "searchnetworking" :
blcss="/TLimages/css/tt-network-content.css"
cid = "512"
siteid = 8
newsletters = 81
newslettername = "SearchNetworking电子新闻邮件"
forumid = 440
wzlink = "http://www.techtarget.com.cn/ttfiles/toparticle/tt_sn_wzlink.js"
jsurl = "http://images.chinabyte.com/techtarget/ad-pip/tt-networking-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-network-tlgg-news.js"
sqjh = "http://searchnetworking.techtarget.com.cn/TT_CLUB_ARTICLE/searchnetworking_article.js"
zizhanname ="网络子站"
break
case "searchexchange" :
blcss="/TLimages/css/tt-exchange-content.css"
cid = "505"
siteid = 9
newsletters = 91
newslettername = "SearchExchange电子新闻邮件"
forumid = 142
resourcejs ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-content-resource.js"
jsurl ="http://images.chinabyte.com/techtarget/ad-pip/tt-exchange-pip.js"
tlgg ="http://images.chinabyte.com/ttfiles/ttimages/cmsflash/tt-exchange-tlgg-news.js"
technet ="http://www.techtarget.com.cn/ttfiles/toparticle/tt-technet1.js"
sqjh = "http://searchexchange.techtarget.com.cn/TT_CLUB_ARTICLE/