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 10g ĬÈϰ²×°´øÀ´µÄÓû§Ãû/ÃÜÂë
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enter ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- -- ......
DATEÊý¾ÝÀàÐÍ
¡¡¡¡Õâ¸öÊý¾ÝÀàÐÍÎÒÃÇʵÔÚÊÇÌ«ÊìϤÁË£¬µ±ÎÒÃÇÐèÒª±íʾÈÕÆÚºÍʱ¼äµÄ»°¶¼»áÏëµ½dateÀàÐÍ¡£Ëü¿ÉÒÔ´æ´¢Ô£¬Ä꣬ÈÕ£¬ÊÀ¼Í£¬Ê±£¬·ÖºÍÃë¡£ËüµäÐ͵ØÓÃÀ´±íʾʲ ôʱºòÊÂÇéÒѾ·¢Éú»ò½«Òª·¢Éú¡£DATEÊý¾ÝÀàÐ͵ÄÎÊÌâÔÚÓÚËü±íʾÁ½¸öʼþ·¢Éúʱ¼ä¼ä¸ôµÄ¶ÈÁ¿Á£¶ÈÊÇÃë¡£Õâ¸öÎÊÌ⽫ÔÚÎÄÕÂÉÔºóÌÖÂÛtimestampµÄʱ ºò±»½â¾ö¡£¿ÉÒ ......
×òÌìÔÚÕûÀíÎļþ¼ÐµÄʱºò²»Ð¡ÐĽ«Ò»¸ödbfÊý¾ÝÎļþÒÆ¶¯ÁË£¬½ñÌìµÇ¼plsqlʱȴ·¢ÏÖÌáʾora-01033£ºoracle initialization or shutdown in progressµÄ´íÎ󣬿ªÊ¼ÒÔsqlnet.oraµÄÎļþÅäÖÃÎļþ£¬µ«ÊǸÄÀ´¸ÄÈ¥»¹ÊǵǼ²»ÁË¡£×îºó°´ÕÕÍøÓѵÄÌáʾ½«sqlnet.oraÎļþÖеÄSQLNET.AUTHENTICATION_SERVICES= (NTS)¸Ä³ÉÁËSQLNET.AUTHENTICATI ......