Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%, 
ÀýÈç:TABLE a
columnA
'222'
'33%44'

ÈçºÎ²éѯ±íaÖÐcolumnA×Ö¶ÎÖÐÄÄЩÐаüº¬'%'

лл
select * from a
where columna like '%/%%' escape '/'

UP

SELECT * from a WHERE columnA LIKE '%\%%' ESCAPE'\';

ÆäÖУ¬ESCAPE'\'±íʾ£º\Ϊ»»Âë×Ö·û£¬Æ¥Åä´®ÖиúÔÚ\ºóÃæµÄ×Ö·û%²»ÔÙ¾ßÓÐͨÅä·ûµÄº¬Ò壻
תÒåΪÆÕͨµÄ¡°%¡±×Ö·û¡£


ÒýÓÃ
select * from a
where columna like '%/%%' escape '/'

UP


Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿

select * from t1 where instr(f1,'%') != 0 ;

ÓÃÕýÔò±í´ïʽ°É£º
select * from dual
where 'tian%dd'like '%/%%' escape '/';

ÒýÓÃ
Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿


select * from t1 where instr(f1,'''') != 0;

ÒýÓÃ
Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿

where col1 like '%''%'
»ò
where col1 like '%'||chr(39)||'%'
»ò
where instr(col1,chr(39))>0


Â¥Ö÷ÓÃOracle ÕýÔòÊÔÊÔ
SQL code:

with tt as (
select '33%44''' COL from dual
)

select * from


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~

table1:
uID    uName
1      СÀî 
2      СÕÅ

table2:
pID  uID  type
1    1    H1
2    ......

ÇóÒ»sqlÓïÃû

ÏÖÔÚÓÐa1,a2Á½±í
a1
id name aa cc
001 aaaa bbb cc
002 bbb bbb bbb
003 ccc ccc ccc
004 ddd ddd ddd
005 eee eee eee
a2
id ida2 ff b ......

SqlÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ