SQL*PlusÖÐ&×Ö·û´¦Àí
ÔÚSQL*PlusÖÐĬÈϵÄ"&"±íÊ¾Ìæ´ú±äÁ¿£¬SQL*PlusÈÏΪ&·ûºóÃæµÄ×Ö·û´®Îª±äÁ¿£»Ö»ÒªÔÚÃüÁîÖгöÏָ÷ûºÅ£¬SQL*Plus¾Í»áÒªÄãÊäÈëÌæ´úÖµ¡£Õâ¾ÍÒâζ×ÅÄãÎÞ·¨½«Ò»¸öº¬Óи÷ûºÅµÄ×Ö·û´®²åÈë»ò¸üе½Êý¾Ý¿â
set define off ¹Ø±ÕÌæ´ú±äÁ¿¹¦ÄÜ£¬“&”½«×÷ΪÆÕͨ×Ö·û
set define on ¿ªÆôÌæ´ú±äÁ¿¹¦ÄÜ
set define * ½«Ä¬ÈÏÌæ´ú±äÁ¿±êÖ¾·û¸ÄΪ“*”(Ò²¿ÉÒÔÉèΪÆäËü×Ö·û)
×¢Ò⣺¸ÃÃüÁîÖ»¶Ôµ±Ç°SQL Command´°¿ÚÓÐЧ£¬´°¿Ú¹Ø±ÕºóÌæ´ú±äÁ¿¹¦ÄÜ×Ô¶¯¹Ø±Õ
Ïà¹ØÎĵµ£º
if object_id('tb') is not null drop table tb
go
create table tb([A] varchar(10),[B] int)
insert tb
select 'bcd',1 union all
select 'bcde',2 union all
select 'cd',3
go
¸öÈË·ÖÎöÕâµÀÌâµÄ˼·ÊÇ£º
ͨ¹ýSubstring() À´Ñ»··Ö¸î B ÁÐϵÄ×Ö·û´®¡£¡£
--ÏëµÃµ½µÄ½á¹û£º
/**
a b& ......
create PROCEDURE sp_decrypt(@objectname varchar(50))
AS
begin
set nocount on
--CSDN£ºj9988 copyright:2004.07.15
--V3.2
--ÆÆ½â×Ö½Ú²»ÊÜÏÞÖÆ£¬ÊÊÓÃÓÚSQLSERVER2000´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬´¥·¢Æ÷
--ÐÞÕýÉÏÒ»°æ"ÊÓͼ´¥·¢Æ÷"²»ÄÜÕýÈ·½âÃÜ´íÎó
--·¢ÏÖÓÐ´í£¬ÇëE_MAIL£ºCSDNj9988@tom.com
begin tran
......
1:replace º¯Êý
µÚÒ»¸ö²ÎÊýÄãµÄ×Ö·û´®£¬µÚ¶þ¸ö²ÎÊýÄãÏëÌæ»»µÄ²¿·Ö£¬µÚÈý¸ö²ÎÊýÄãÒªÌæ»»³Éʲô
select replace('lihan','a','b')
&nb ......
detachedCriteria.add(Restrictions.or(
Restrictions.like("chengBanDanWeiIds", rForm.getChengBanDanWeiIds()+(char)13, MatchMode.START),
Restrictions.or(
&n ......
Ö£ÖØÉùÃ÷һϣ¬ÕâÆªÈÕÖ¾ÊÇÎÒCopyµÄ£¬²»ÊÇ×Ô¼ºÐ´µÄ£¬ÎÒ»¹Ã»ÄÇôǿ£¡(×Ðϸ¿´Ò»Ï£¬ÓÐÓá£)
¹ØÓÚSQLÓï¾äÖеÄË«ÒýºÅ¡¢µ¥ÒýºÅ£º
£¨1£©ÏÈÀ´¿´Ò»¸ö×î¼òµ¥µÄSQLÓï¾ä
Insert Into users(username) values("СÍõ")
´ó¼ÒÀ´¿ ......