Oracle TRANSLATEÓ÷¨
	
    
    
	Óï·¨£ºTRANSLATE(expr,from,to)
expr: ´ú±íÒ»´®×Ö·û£¬from Óë to ÊÇ´Ó×óµ½ÓÒÒ»Ò»¶ÔÓ¦µÄ¹ØÏµ£¬Èç¹û²»ÄܶÔÓ¦£¬ÔòÊÓΪ¿ÕÖµ¡£
¾ÙÀý£º
select translate('abcbbaadef','ba','#@') from dual¡¡£¨b½«±»££Ìæ´ú£¬a½«±»£ÀÌæ´ú£©
select translate('abcbbaadef','bad','#@') from dual¡¡£¨b½«±»££Ìæ´ú£¬a½«±»£ÀÌæ´ú£¬d¶ÔÓ¦µÄÖµÊÇ¿ÕÖµ£¬½«±»ÒÆ×ߣ©
Òò´Ë£º½á¹ûÒÀ´ÎΪ£º@#c##@@def ºÍ@#c##@@ef
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    ORACLE EXP/IMP ²ÎÊýÏê½â
2008-01-09 18:16
ORACLE EXP/IMP ²ÎÊýÏê½â
===========================================================
×÷Õß: magic21(http://magic21.itpub.net)
·¢±íÓÚ: 2007.09.27 10:46
·ÖÀà: ÈÕ»ýÔÂÀÛ 
³ö´¦: http://magic21.itpub.net/post/5324/400048
-------------------------------------- ......
	
    
        
    
    Á˽âLDAP     
    
LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊÐÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£    
LDAPÐÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......
	
    
        
    
    Ò»¡¢ÀûÓÃClass.forNameº¯Êý£¨ÓÃjava¿ª·¢B/SģʽµÄ³ÌÐò£©     1.´úÂëÈçÏ£º         //×¢²áÇý¶¯³ÌÐò
   public boolean connectDb() {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			return true;
		} catch (ClassNotFoundException e) {
			System.out.println(e);
			return false;
		}
	}
 ......
	
    
        
    
    ͨ¹ýJAVAµ÷ÓÃORACLEµÄ´æ´¢¹ý³Ì£¬ÔÚORACLEµÄ´æ´¢¹ý³ÌÄÚ²¿×öÁËÒ»¸ö²éѯÔÚJAVAÖлñÈ¡¸Ã²éѯ½á¹û£¬Õâ¸öºÍSYBASE¡¢SQLSERVERµÄ»ñÈ¡²»Ò»Ñù£¬µÈÎÒµÄÏÂһƪÎÄÕÂÎÒ»á½éÉÜÈçºÎ»ñÈ¡SYBASE¡¢SQLSERVERÔÚ´æ´¢¹ý³ÌÖÐÖ´ÐÐÁ˲éѯºóÈçºÎ»ñÈ¡Æä½á¹û¼°´æ´¢¹ý³ÌµÄ±àд¡£
ÔÚOracleÖÐÐèÒª·µ»Ø²éѯ½á¹û¼¯£¬±ØÐ뽫ÆäÒÔÓαêµÄÐÎʽ·µ»Ø£¬µ«ÓαêÓÖ²»ÊÇ ......
	
    
        
    
    Ò».±í¿Õ¼äѧϰ
¸öÈ˾õµÃ±í¿Õ¼äÏà¶ÔÓÚÊý¾Ý¿âÀ´ËµÊÇÖÁ¹ØÖØÒªµÄ£¬Ò»°ã·ÖΪpermanent(ÓÀ¾ÃÐÔ±í¿Õ¼ä),undo(undo±í¿Õ¼ä),temporary(ÁÙʱ±í¿Õ¼ä),Ò»°ãÎÒÃÇÊÇͨ¹ýÒÔÏÂsql½øÐв鿴±í¿Õ¼äµÄÀàÐ͵Ä.
select distinct t.contents from dba_tablespaces t;
²é¿´±í¿Õ¼äËù¶ÔÓ¦µÄÊý¾ÝÎļþ¡£
select t.name,t1.name 
from v$tablespace  ......