Oracleºº×ÖÅÅÐò
	
    
    
	
ʹÓÃÒ»ÏÂSQL
select * 
from T_0303003 
order by stock_holder
½øÐÐѡȡÊý¾Ýʱ£¨stock_holderΪ´æ·ÅÖÐÎĵÄ×ֶΣ©£¬½á¹û·¢ÏÖÁ½¿â·µ»ØµÄ¼Ç¼˳Ðò²»Ò»Ö¡£×ÁÄ¥Ö®ºóÓ¦¸ÃΪ×Ö·û¼¯ÎÊÌ⣬һ¸ö¿â×Ö·û¼¯ÎªÏµÍ³Ä¬ÈÏ×Ö·û¼¯£¬ÁíÒ»¸ö¿âΪUTF-8×Ö·û¼¯¡£²éÕÒ×ÊÁϺó·¢ÏÖ£¬¶ÔÓÚÖÐÎÄ×ֶεÄÅÅÐò£¬Ó¦¸ÃʹÓÃÒÔÏ·½Ê½£º
-- °´Æ´ÒôÅÅÐò (ϵͳĬÈÏ)
select * 
from T_0303003 
order by nlssort(stock_holder,'NLS_SORT=SCHINESE_PINYIN_M');
-- °´²¿Ê×ÅÅÐò 
select * 
from T_0303003 
order by nlssort(stock_holder,'NLS_SORT=SCHINESE_RADICAL_M');
-- °´±Ê»ÅÅÐò 
select * 
from T_0303003 
order by nlssort(stock_holder,'NLS_SORT=SCHINESE_STROKE_M');
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    
ÍæOracleÒ²ÓÐ2ÄêµÄʱ¼äÁË£¬ ÁãÁãɢɢµÄÒ²ÕûÀíһЩ×ÊÁÏ¡£ ¶«Î÷Ò»¶àÁË£¬¾ÍÀí²»Çå³þ¡£ ËùÒÔ½áºÏÕÅÏþÃ÷µÄ¡¶´ó»°Oracle RAC¡·µÄһЩÄÚÈÝ£¬ºÍ×Ô¼ºÕûÀíµÄһЩ±Ê¼Ç£¬¶ÔOracle µÄ±¸·ÝºÍ»Ö¸´×öÁËÒ»¸öϵͳµÄÕûÀí¡£ Ò²ÊÇ×Ô¼º¶Ô֪ʶµÄÒ»¸ö¹®¹Ì°É¡£ 
Ò»£® ×¼±¸ÖªÊ¶
ÏÈÀ´¿´Ò»Ð©×¼±¸ÖªÊ¶£¬Á˽â ......
	
    
        
    
    --¶¨ÒåÀàÐÍ
CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2(4000);
--´´½¨º¯Êý
CREATE OR REPLACE FUNCTION f_stringsplit (p_str IN VARCHAR2, p_delimiter IN VARCHAR2)
    RETURN ty_str_split PIPELINED
/*****
****×Ö·û´®²ð·Ö,Ï൱ÓÚjava.lang.StringÀàµÄsplit·½·¨
****×¢Òâ:ÐÂÔöt ......
	
    
        
    
    ORACLE EXP/IMP ²ÎÊýÏê½â2010-03-22 17:53OracleÊý¾Ý¿âʹÓÃIMP/EXP¹¤¾ß½øÐÐÊý¾Ýµ¼ÈëÓëµ¼³ö½éÉÜ£º
1.ʹÓÃÃüÁîÐУº
Êý¾Ýµ¼³ö£º
1.½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§ÃûsystemÃÜÂëmanagerµ¼³öµ½D:\Test_bak.dmpÖÐ
exp system/manager@ora10 file=d:\Test_bak.dmp full=y
ora10±íʾÊý¾Ý¿âÃû
2.½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ ......
	
    
        
    
    @@servername:·µ»ØÔËÐÐSQL ServerÊý¾Ý¿â±¾µØ·þÎñÆ÷µÄÃû³Æ¡£ 
@@remserver:·µ»ØµÇ¼¼Ç¼ÖмÇÔØµÄÔ¶³ÌSQL Server·þÎñÆ÷µÄÃû³Æ¡£ 
@@connections:·µ»Ø×ÔÉÏ´ÎÆô¶¯SQL ServerÒÔÀ´Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý£¬ÓÃÆä¿ÉÈùÜÀíÈËÔ±·½±ãµØÁ˽â½ñÌìËùÓÐÊÔͼÁ¬½Ó·þÎñÆ÷µÄ´ÎÊý¡£ 
@@cursor_rows:·µ»Ø×îºóÁ¬½ÓÉϲ¢´ò¿ªµÄÓαêÖе±Ç°´æÔڵĺϸñ ......