ORACLEÖÐËÑË÷×ÖĸÊý×Ö»ìºÏµÄ×Ö·û´®
SQL> with tt as
2 (
3 select 'haha' string from dual union
4 select '123' from dual union
5 select 'haha12' from dual union
6 select 'haha[]' from dual union
7 select '12@@' from dual union
8 select 'ah@!123' from dual
9 )
10 select string
11 from
12 (
13 select string,translate(
14 string,'abcdefghijklmnopqrstuvwxyz0987654321',
15 rpad('#',26,'#')||rpad('*',10,'*')
16 )
17 translated from tt
18 )
19 where instr(translated,'#') > 0
20 and instr(translated,'*') > 0;
STRING
-------
ah@!123
haha12
Æäʵ¾ÍÊÇͨ¹ýtranslateº¯Êý°ÑËùÓÐ×ÖĸºÍÊý×ֱ任³ÉÁ½ÖÖͳһµÄ×Ö·û£¬ÉÏÀýÖÐÊǰÑ×Öĸ±äΪ#£¬Êý×Ö±äΪ*£¬½Ó×ÅÔÙÍâ²ãselectµÄwhere×Ó¾äÖжÔת»»ºóµÄ×Ö·û´®½øÐÐÅжϣ¬Èç¹ûÁ½Õß¶¼´óÓÚ0£¬Ò²¾Í˵¼ÈÓÐ×ÖĸҲÓÐÊý×Ö£¬ÄÇô¾ÍûÎÊÌâÁË¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
oracle+jspÖÐblobÀàÐÍ´æ´¢´óÎı¾ÎÊÌâ½â¾ö·½·¨
oracle ´æ´¢´óÎı¾Ò»Ö±ÊÇÒ»¸ö¼¬ÊÖµÄÎÊÌâ¡£
Ò»¡¢´æÊý¾Ý¿â£º
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
//¶¨Òå±äÁ¿
java.sql.Connection conn; //Êý¾ ......
DBVERIFY¹¤¾ßµÄÖ÷ҪĿµÄÊÇΪÁ˼ì²éÊý¾ÝÎļþµÄÎïÀí½á¹¹£¬°üÀ¨Êý¾ÝÎļþÊÇ·ñË𻵣¬ÊÇ·ñ´æÔÚÂß¼»µ¿é£¬ÒÔ¼°Êý¾ÝÎļþÖаüº¬ºÎÖÖÀàÐ͵ÄÊý¾Ý¡£
DBVERIFY¹¤¾ß¿ÉÒÔÑéÖ¤ONLINE»òOFFLINEµÄÊý¾ÝÎļþ¡£²»¹ÜÊý¾Ý¿âÊÇ·ñ´ò¿ª£¬¶¼¿ÉÒÔ·ÃÎÊÊý¾ÝÎļþ¡£
1.¿ÉÒÔʹÓðïÖú²é¿´dbvµÄÃüÁî²ÎÊý
C:\>dbv help=y
DBVERIFY: Release 11. ......
1¡¢Ð½¨PDM.ÓÒ»÷Workspace->New->Free Model->Physical Data Model
2¡¢Model nameÈÎÒâ, DBMS=>ORACLE Version 9i2->È·¶¨
3¡¢ÅäÖÃODBC
¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->Êý¾ÝÔ´(ODBC)->ϵͳDSN->Ìí¼Ó,Èç¹ûÓÐ×°ÍêÕûµÄOracle¿Í»§¶Ë»á³öÏÖרÃŵÄÇý¶¯,ÎÒµÄÊǼò°æµÄ¾ÍÑ¡
"Microsoft ODBC for Oracl ......