ÐèÒª¶ÔһЩWORDÎĵµ½øÐÐÈ«ÎļìË÷£¬Êý¾Ý¿â°æ±¾oracle 9i R2£¬ÎÒÊÇÉúÊÖÇë¶àÖ¸½Ì£¬Ð»Ð»¡£
±í:
create table textdemo(id number(3) primary key,content blob);
Ë÷Òý£º
create index t_textdemo_idn on textdemo(content) indextype is ctxsys.content;
Ò»¡¢ÒѾ°ÑwordÎĵµ×ª»¯Îª¶þ½øÖÆ´æÈëblobÁУ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
0003,MARY
Ó¦¸ÃÔõô×öÄØ?
´ð°¸ÊÇ ÉÆÓà Concatenation Operator ||
¶øÉÏÊöµÄÎÊÌâ
Ö»ÒªÕâôÏÂSQL ¾Í¿ ......
[size=11px][/ÎÒÊÇÒ»¸öVBÐÂÊÖ£¬ÏëѧϰһÏÂÔõôÓÃADOÁ¬½ÓORACLE,ÔÚÂÛ̳¿´Á˰ëÌìµÄÌù×Ó£¬Ô½À´Ô½ºýÍ¿£¬Ï£Íû´óϺÃÇÄܸø¸öÏêϸµãµÄ½Ì³Ì£¡£¡[size]
²»Òª¿´Ìù×Ó£¬ÏÈ¿´Ò»Ï£Á£Ä£ÏµÄ½éÉÜ£¬ÆäÖÐÓкܶàÀý×Ó¡£
¸øÄã¶Î´úÂ룬¿´ÄÜ·ñ¿´¶®
'ÒýÓÃado¶ÔÏó2.5
Dim cnGet As ADODB.Connection
Dim rsGet As ADODB.Recordset
......
¸÷λ´ó¸ç´ó½ã¾ÈÃüѽ£¡£¡Êý¾Ý¿â´ó×÷Òµ×öµ½×îºó¹Ø¼üʱ¿ÌÔªµ©±»¿¨ÁË3Ì죬ÏÂÖÜÒª½»ÁË¡£ÎҵĻ·¾³ÊÇwindows2003+oracle9i£¬ODBCµÄDATA SOURCE NAME:DZSW;TNS:MYSW;USER:SCOTT£¨½¨±íµÄÓû§£©;PASSWORD:TIGER;testconntion²âÊÔʱ³É¹¦£»µ«ÓÃÁ¬½Ó´úÂëcommon/conn.asp£º <%
'Á¬½ÓÊý¾Ý¿â
dim conn
......
jspÈçºÎ½«oracle´æ´¢¹ý³Ì·µ»ØµÄ½á¹û¼¯±£´æµ½txtÎı¾ÖУ¿Çë¸÷λ¸ßÊÖÖ¸µã£¡Ð»Ð»£¡
×Ô¼º¶¥Ò»ÏÂ
¾Í¸úÒ»°ãµÄResultSetÒ»Ñù°¡¡£ÄãÈ¡rsÊý¾Ý»áÈ¡°É£¿
ÔÚÒ³ÃæÏÔʾÎÒÖªµÀ£¬¾ÍÊDz»ÖªµÀÍùTXTÀïÔõôд£¬Äܲ»Äܸø¸ö´úÂëÑÝʾһÏ£¿
дtxt¾ÍÊÇÎļþ´æÈ¡°¡¡£
¸øÄãÍæÍæ¡£Ã»È¥È¡rsÊý¾Ý£¬ÀÁµÃŪÁË¡£ÆäʵÕâÐ©ÍøÉϺܶàµÄ¡£
Jav ......
Ôõô°Ñһ̨µçÄÔÖеıí¿Õ¼äÒÆ¶¯µ½Áíһ̨ÖÐÓã¿
ORACLE¡¡£±£±£Ç
¾ßÌåµãлл£¬×îºÃÄܾٸöÀý×Ó£¬ÍøÉϵͼÊÇ£¸iµÄ²Ù×÷²½Ö裬²»ÔõôºÃÓÃ
ÒýÓÃ
Ôõô°Ñһ̨µçÄÔÖеıí¿Õ¼äÒÆ¶¯µ½Áíһ̨ÖÐÓã¿
ORACLE¡¡£±£±£Ç
¾ßÌåµãлл£¬×îºÃÄܾٸöÀý×Ó£¬ÍøÉϵͼÊÇ£¸iµÄ²Ù×÷²½Ö裬²»ÔõôºÃÓÃ
Êý¾Ý°áǨ£¿ Â¥Ö÷»¹ÊÇ˵Çå³þµã°É¡£
---- ......