Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle×Ö·û¼¯£¨³¬seÇ飩£º

oracle ÀïÃæµÄ×Ö·û¼¯£¬±ÈÈçWE8ISO8859P1£¬ZHS16GBK£¬AL16UTF16£¬AL32UTF8£¬µÈµÈ³£ÓõÄ×Ö·û¼¯¡£ËüÃǵĴóС°üº¬¹ØÏµÊÇʲôÑù×Ó£¿
ÒÔ¼°ËüÃǵĴ洢·½Ê½£¿
ORACLE×Ö·û¼¯µÄ°üº¬¹ØÏµ 

8.1.6 ×Ó¼¯/³¬¼¯Áбí
=========================== 
A.µ±Ç°×Ö·û¼¯ B.¿ÉÒÔÐ޸ĵ½µÄÐÂ×Ö·û¼¯(AµÄ³¬¼¯) 
------------------- -------------------------------- 
US7ASCII WE8DEC 
US7ASCII US8PC437 
US7ASCII WE8PC850 
US7ASCII IN8ISCII 
US7ASCII WE8PC858 
US7ASCII WE8ISO8859P1 
US7ASCII EE8ISO8859P2 
US7ASCII SE8ISO8859P3 
US7ASCII NEE8ISO8859P4 
US7ASCII CL8ISO8859P5 
US7ASCII AR8ISO8859P6 
US7ASCII EL8ISO8859P7 
US7ASCII IW8ISO8859P8 
US7ASCII WE8ISO8859P9 
US7ASCII NE8ISO8859P10 
US7ASCII TH8TISASCII 
US7ASCII BN8BSCII 
US7ASCII VN8VN3 
US7ASCII VN8MSWIN1258 
US7ASCII WE8ISO8859P15 
US7ASCII WE8NEXTSTEP 
US7ASCII AR8ASMO708PLUS 
US7ASCII EL8DEC 
US7ASCII TR8DEC 
US7ASCII LA8PASSPORT 
US7ASCII BG8PC437S 
US7ASCII EE8PC852 
US7ASCII RU8PC866 
US7ASCII RU8BESTA 
US7ASCII IW8PC1507 
US7ASCII RU8PC855 
US7ASCII TR8PC857 
US7ASCII CL8MACCYRILLICS 
US7ASCII WE8PC860 
US7ASCII IS8PC861 
US7


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

oracle֪ʶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£»
select * from
  (select * from table order by col_name desc)
where rownum<=3;

select * from
(
select s.*,rownum rn 
from t3 s
)
where ......

oracleÊý¾Ý¿â - Oracle / ¸ß¼¶¼¼Êõ

ÔÚOracleÖÐÔõôɾ³ýÖØ¸´µÄÐУ¬µ«Òª±£ÁôÒ»Ìõ¼Ç¼¡£

delete table where rowid not in (select max(rowid) from table group by col1,col2,...,coln);

¶Ô£¬ÓÃrowid À´¹ýÂË.

delete tb a
where a.rowid > ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ