oracle ³£¼ûµÄº¯Êý
	
    
    
	1. ASCII 
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý; 
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual; 
A A ZERO SPACE 
--------- --------- --------- --------- 
65 97 48 32 
2. CHR 
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û; 
SQL> select chr(54740) zhao,chr(65) chr65 from dual; 
ZH C 
-- - 
ÕÔ A 
3. CONCAT 
Á¬½ÓÁ½¸ö×Ö·û´®; 
SQL> select concat(010-,88888888)||ת23 ¸ßǬ¾ºµç»° from dual; 
¸ßǬ¾ºµç»° 
---------------- 
010-88888888ת23 
4. INITCAP 
·µ»Ø×Ö·û´®²¢½«×Ö·û´®µÄµÚÒ»¸ö×Öĸ±äΪ´óд; 
SQL> select initcap(smith) upp from dual; 
UPP 
----- 
Smith 
5.INSTR(C1,C2,I,J) 
ÔÚÒ»¸ö×Ö·û´®ÖÐËÑË÷Ö¸¶¨µÄ×Ö·û,·µ»Ø·¢ÏÖÖ¸¶¨µÄ×Ö·ûµÄλÖÃ; 
C1 ±»ËÑË÷µÄ×Ö·û´® 
C2 Ï£ÍûËÑË÷µÄ×Ö·û´® 
I ËÑË÷µÄ¿ªÊ¼Î»ÖÃ,ĬÈÏΪ1 
J ³öÏÖµÄλÖÃ,ĬÈÏΪ1 
SQL> select instr(oracle traning,ra,1,2) instring from dual; 
INSTRING 
--------- 
9 
6.LENGTH 
·µ»Ø×Ö·û´®µÄ³¤¶È; 
SQL> select name,length(name),addr,length(addr),sal,length(to_char(sal)) from gao.nchar_tst; 
NAME LENGTH(NAME) ADDR LENGTH(ADDR) SAL LENGTH(TO_CHAR(SAL)) 
------ ------------ ---------------- ------------ --------- -------------------- 
¸ßǬ¾º 3 ±±¾©Êк£¶§Çø 6 9999.99 7 
7.LOWER 
·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд 
SQL> select lower(AaBbCcDd)AaBbCcDd from dual; 
AABBCCDD 
-------- 
aabbccdd 
8.UPPER 
·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·û´óд 
SQL> select upper(AaBbCcDd) upper from dual; 
UPPER 
-------- 
AABBCCDD 
9.RPADºÍLPAD(Õ³Ìù×Ö·û) 
RPAD ÔÚÁеÄÓÒ±ßÕ³Ìù×Ö·û 
LPAD ÔÚÁеÄ×ó±ßÕ³Ìù×Ö·û 
SQL> select lpad(rpad(gao,10,*),17,*)from dual; 
LPAD(RPAD(GAO,1 
----------------- 
*******gao******* 
²»¹»×Ö·ûÔòÓÃ*À´ÌîÂú 
10.LTRIMºÍRTRIM 
LTRIM ɾ³ý×ó±ß³öÏÖµÄ×Ö·û´® 
RTRIM ɾ³ýÓұ߳öÏÖµÄ×Ö·û´® 
SQL> select ltrim(rtrim( gao qian jing , ), ) from dual; 
LTRIM(RTRIM( 
------------- 
gao qian jing 
11.SUBSTR(string,start,count) 
È¡×Ó×Ö·û´®,´Óstart¿ªÊ¼,È¡count¸ö 
SQL> select substr(13088888888,3,8) from dual; 
SUBSTR( 
-------- 
08888888 
12.REPLACE(string,s1,s2) 
string Ï£Íû±»Ìæ»»µ
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    ORACLE 10 ѧϰ±Ê¼Ç-µÚ2½Ú-ÃüÁî¡£
1. inner join / left join/ right join / full join 
select a.dname, b.ename from dept a, emp b where a.deptno=b.deptno and a.deptno=10;
select a.dname, b.ename from dept a inner join emp b 
on a.deptno=b.deptno and a.deptno=10;
select dname,ename from dept natural ......
	
    
        
    
    
 
IP µØÖ·×öÈçÏÂÐ޸ģº
Public IP 10.85.10.119/121    -- >  10.85.10.219/221
Privite IP 192.168.1.119/121   -- >  192.168.1.219/221
Virtual IP 10.85.10.122/123   --  ......
	
    
        
    
    °´±í·½Ê½µÄµ¼³ö£¬µ¼Èë
exp SYSTEM/SYSTEM@SBJSDB00 TABLES=KOKAN90.MASTER_SEND_LIMIT LOG=C:\A.LOG
IMP SYSTEM/SYSTEM@SBJSDB00 IGNORE=Y FULL=Y LOG=C:\B.LOG
֮ǰÓùýºÜ¶àÓï¾ä¶¼±¨´í£¬µÃµ½µÄ½ÌѵÊÇ ÏÈÖ´ÐÐexp SYSTEM/SYSTEM@SBJSDB00£¬°´Ìáʾһ²½²½ÊäÈë³É¹¦¹ýºó£¬ÔÙ°ÑÌáʾ·Òë³É²ÎÊýºÍ²ÎÊýÖµ
¹ØÓÚ²ÎÊý˵Ã÷Óà exp hel ......
	
    
        
    
    Oracle EBS AlertÔÚOracle EBSÖÐÓ¦Ó÷dz£¹ã·º,Ö÷Òª¼¯ÖÐÔÚ¶¨ÆÚ֪ͨºÍÌáÐÑ,ʼþÀàµÄ֪ͨºÍÌáÐÑ,ÀýÈç:
1)ij¸öÖ°Ô±¹ýÉúÈÕ,µ«ÊÇÈËÁ¦×ÊÔ´²¿ÃÅÏ£Íû·¢¸ö×£ºØµÄÓʼþ,¾Í¿ÉÒÔͨ¹ýAlert½øÐÐ֪ͨףºØ;
2)ÔÚDBA¼ì²âϵͳÊÇ·ñÕý³£ÔËתµÄ¹ý³ÌÖÐ,Èç¹ûij¸ö±í¿Õ¼ä¿ìÂúÁË,¿ÉÒÔ½¨Á¢Alert½øÐÐ֪ͨ¹ÜÀíÔ±;
3)¿ÉÒÔ½øÐÐÌáÐÑEBSÖеÄËùÓÐÈËÔ±,µ±È»Ò²¿ ......
	
    
        
    
    1¡¢OracleµÄPackage³ýÁ˰Ѵ洢¹ý³Ì·Åµ½Ò»¶Ñ¶ùÒÔÍ⻹ÓÐûÓÐÆäËûµÄ×÷Ó㨺ô¦£©£¿
2¡¢ÈçºÎ°ÑÏÖÓеĴ洢¹ý³Ì¼ÓÈëµ½PackageÖУ¿
3¡¢³ýÁËʹÓÃSQL Plus£¬»¹ÓÐûÓÐʲô¹¤¾ß×öPackage?
4¡¢Ê¹ÓÃSQL Plus±àÒëPackage£¬ÊÇ·ñÿ´Î¶¼ÊDZàÒëPackageÖÐËùÓеĴ洢¹ý³Ì£¿
1¡¢Äã²»¾õµÃ°Ñ´æ´¢¹ý³Ì·ÖÃűðÀàÊǺÜÖØÒªµÄô£¬¶øÇÒ²»Í¬µÄpackageµÄ ......