注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

lazydba

hello

 
 
 

日志

 
 

like  

2008-03-07 16:52:10|  分类: all about databa |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
select * from dual where '_' like 'a';
?
create table t(b varchar2(1));
insert into t values('_');
insert into t values('%');
select * from t where '%' like b;
select * from t where '%%' like b;

  评论这张
 
阅读(92)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引覿tape} { maink}/?from=blog/static/17280971220082745210733">${y.recommendBuhidbds2target="_blank" hme, .recommenderNic blogTitle:'like', n(x.title.erNickname,6)|rc=3if}p {/ixin aluejv> .reco ae nbw-f4)}"/;%E6%92% onnews" blomme k nbw-fcbphide xtag"> > B5085 onne.nbw-fcbphide xtag">5085k nbw-fce nbwar_ .reco ae nbw-f4)}"/;%E6%92% onnews" blommRecoP bw-fcbphide InfoNick {/list} bw-fcbphide xtag">5/textarea> name="jst <#--引覿li> { ma博主b asom=blog/static/17280971220082745210733">

· {/if} li> { ma随机2bla> .recommenass="iblock nbw-fce nbw-f40"">· {/if} li> { ma 8la> .recommenass="iblock nbw-fce nbw-f40"">· {/if} li> { maclass="cnt zom=blog/static/17280971220082745210733">1rget="_bl {x.visitor
· ${fn(a.nickname,8)|ebpitorNickn/.title,26)|es|defa

推荐过这

·${fn(x.title,26)|escaw-fc rm lo, {/list} <#--推荐日志--> li> { http jst n">&新闻广告 t" src > {list a as x} {if !!1罩镜娜薳scaaaaa5k nbw-fce n类
    n">&新闻
caaaaaaa5k nbw-fce nrc=sdiv>{x.visitocaaaaaaaaa5 href="hthlasrc=syle="font-size:14pxref="http://blog.mendB.thlasdiv s.${f_3w {/list>{x. 2008-03-07escap defiv !!erc=s x_ ex>7}{b ks ztaght 2caaaaaaa&&aa5">· caaaaaaacaaaaa {/if} 2caaaaaaa <#--引 2caaaaaaa k nbw-fce ndisg.src x. 2caaaaaaacaaa5 href="ht="_&新闻>  caaaaaaa5 {/lli> { http jst右边模块结构om=blog/static/17280971;&niv cla {i;&n-rget="_bl k nbw-fce nui phide xtag"> caaa5>热度="_b _163 phide 被b as="m-tag clearfi {/ixin ght bbl ass {x.visi">历史上的="_b _163 phide name="jtag clearfi {/ixin ght bbl ass {x.visi">历史上的="_b _163 phide 该作者的其他 tag clearfi {/ixin ght bbl ass {x.visi">历史上的="_b _163 phide 博主b astag clearfi {/ixin ght bbl ass {x.visi">历史上的="_b _163 phide 随机2历史上的="_b _163 phide 更多v>pe=} hide xtag"nbwss=bwsshttp:/5k nbay:n 32px;text-"adlink" hre;
caaa5k nbw-fce noca="$_lticntwr:1;">
itm
Wr=img.htm asswumiiR ht 5k nbw-fce nl h" ala03 xtag k nshttp:/aa5k nbw-fce nr thh" ala03 xtag k nshttp:/ssk nshtaa a5k nbw-fce nc lcbtc thbhiv>
#d7854ssk nshtaa a5sk nshttpssk nsht 5k nbw-fce nl t zg lghh" ala03 xtag k nshttp:/ a5k nbw-fce n/di-f4 ltla03 xtag k nshttp:/aa5k nbw-fce n/di-fbtcan>#d7854ssk nshtaa a a5k nbw-fce ntt#d7854ssk nshtaa assk nsht a5sk nshttpsk nbw-fce nc le">
 
 
页 志>http:/aa a s hclafram pan> ruev> 8/dref="http://blogrmendBlogPerm;| ruev> 8/dref="http://blogrmendBlogPerm?fros ruev> 8/dref="http://blogrmendBlogPerm?fros nbsp; ruev> 8/dref="http://blogrmendBlogPermgpost_20131023_sp; 下tryER220誣bllass="prig APP} x.aa a http://b51075hclafronefos=> A2%E5"sp;ogc /rss+xm" hrm loftRSSus="truetatic/1728097122008274521073rss/
8/day:naoshotn0 icn0-919"> 订阅

v> 8/> <此博客} ssbw-fchtaa a5sk nshttptp<

<8lan">&公司版权所有#d7854©1997-g =7x} 5sk nsht5sk ns5sk nshtaa a5!--[> nef IE 6]assk ns nef IE 6]assk nspe}aa > {lrows=" ;" s=" s="i="f !iv clac lf !!ax} aa hclafram pan> p32pref="http://blogrmendBlogPermhelps r #d7854ssbw-fchtca hbw-f4)p32pref="http://blogrmendBlogPerm?fros { aa > {lrows=" ;" s=" s="i="f !iv clac lf !!drgeaa a http:/aa a rue" hrmendB"> A2%Eof(y.v) pndua"_b'x.ty.v}rNickn.ty_ exs ztag > { aa > {lrows=" ;" s=" s="i="f !iv clac lf !!dx} b> defiv !!ewl')}http://b a rue" hrmendB"> >httpw ow.Nblo{tm:{'z载<'us:载<' frienaa a'bdc0'usbdc0',sbdc2'usbdcunt:' 202ca' 'usb ',sbgc1'usb untsbgc2'usbgc2'tsbgh 'usb 9' 202ca'> 'us> 3'ts> 1'us> 4'ts> 2'us> 5'ts> 3'us> 6'ts> 4'us> 7'ts> 5'us> 9'}};httphttpuplrvTaltblo'10/23/g =7 06:49: 5';http" src="${apiblo'tatic/1api02016620112520';http" src="${ms/blo'tatic/1api02016620112520ms//_ne';http" src="${_newlo'tatic/1api020166201125207280971/_ne';http" src="${vcdwlo'tatic/1api02016620112520f40/f40hidaextax?pe">ntI%9A7act=qbb ';http" src="${mrtwlo'tatic/1blog.png?1" /> tatmon/tatmon/fd n60.get';http" src="${3140lo'tatic/1blog.png?1" />tatmon/fd n140.get';http" src="${3 = c .f140;http" src="${adf140lo'tatic/1blog.png?1" />tatmon/admimend n140.get';http" src="${eptwlo'tatic/1blog.png?1" />tatmon/v>pty.get';http" src="${gu163_pro0x2e_addlo'tatic/1blog.png?1" />tatmon/gu163_pro0x2e_add.gif';http" src="${p"发to_d molo'tatic/1pntto.d ms m/b';httpw ow.CFolo{http:/ca', http:,wid:-3http:,cb http:,cc', http:,c'', http:,cank-3 http:,ck:0http:,ci:['api0201662011252 /images/microb1log.png?1" /> r/j/pc.js?v=l="8324396838lasswumiiR htaa a wumiiRelatedItems"> /images/microb1log.png?1" /> r/j/m/ {/pm.js?v=l="8324396838lasswumiiR htaa wumiiReg/TlZCWHdFWF Dateltiss /javswumiiRlasswumiiR htaa wumiiReA2%E5"> /javswumiiRlahttp:a_daos_nacc=33', ';type=klTal ker();http
ntt" c.> /javswumiiRlahttp:aw ow. Taltout(funtext?(){ht 20J..srcSumiiR('tatic/1music.phpng?1" />phpjs?0 1'rear 20ar 20J.t:'0httaByDWR( c ._ne,'MusicBeanNewe,'we MusicSessxt?Ttry<' rear },=0a0rearsswumiiR laar fswumiiR>htw ow. Taltout(funtext?(){http to t wumiiR = docute:{.v\> regt:2w/cls/js/?fro_aswlf_V3_1pjs';http docute:{.body.sp;divChild(wumiiRrearaa a },300rear fsswumiiR class=" wumiiReA2%E5"> /javswumiiRl/image/掌 spa"0,="ht/spattime.js asswumiiR htht 謙ml>ht