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

Àí½âOracle×Ö·û¼¯ÎÊÌâ

Ò»£®ÒýÑÔ
    ORACLEÊý¾Ý¿â×Ö·û¼¯£¬¼´OracleÈ«Çò»¯Ö§³Ö(Globalization Support)£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLEΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle¿ÉÒÔÖ§³Ö¶àÖÖÓïÑÔ¼°×Ö·û¼¯£¬ÆäÖÐoracle8iÖ§³Ö48ÖÖÓïÑÔ¡¢76¸ö¹ú¼ÒµØÓò¡¢229ÖÖ×Ö·û¼¯£¬¶øoracle9iÔòÖ§³Ö57ÖÖÓïÑÔ¡¢88¸ö¹ú¼ÒµØÓò¡¢235ÖÖ×Ö·û¼¯¡£ÓÉÓÚoracle×Ö·û¼¯ÖÖÀà¶à£¬ÇÒÔÚ´æ´¢¡¢¼ìË÷¡¢Ç¨ÒÆoracleÊý¾Ýʱ¶à¸ö»·½ÚÓë×Ö·û¼¯µÄÉèÖÃÃÜÇÐÏà¹Ø£¬Òò´ËÔÚʵ¼ÊµÄÓ¦ÓÃÖУ¬Êý¾Ý¿â¿ª·¢ºÍ¹ÜÀíÈËÔ±¾­³£»áÓöµ½ÓйØoracle×Ö·û¼¯·½ÃæµÄÎÊÌâ¡£±¾ÎÄͨ¹ýÒÔϼ¸¸ö·½Ãæ²ûÊö£¬¶Ôoracle×Ö·û¼¯×ö¼òÒª·ÖÎö
¶þ£®×Ö·û¼¯»ù±¾ÖªÊ¶
2.1×Ö·û¼¯
    ʵÖʾÍÊÇ°´ÕÕÒ»¶¨µÄ×Ö·û±àÂë·½°¸£¬¶ÔÒ»×éÌض¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬÊýÖµ±àÂëµÄ¼¯ºÏ¡£OracleÊý¾Ý¿â×îÔçÖ§³ÖµÄ±àÂë·½°¸ÊÇUS7ASCII¡£
    OracleµÄ×Ö·û¼¯ÃüÃû×ñÑ­ÒÔÏÂÃüÃû¹æÔò:
    <Language><bit size><encoding>
    ¼´:  <ÓïÑÔ><±ÈÌØλÊý><±àÂë>
    ±ÈÈç: ZHS16GBK±íʾ²ÉÓÃGBK±àÂë¸ñʽ¡¢16루Á½¸ö×Ö½Ú£©¼òÌåÖÐÎÄ×Ö·û¼¯
2.2×Ö·û±àÂë·½°¸
<st1:chsdate year="1899" month="12" day="30" islunardate="False" isrocdate="False" w:st="on">2.2.1</st1:chsdate> µ¥×Ö½Ú±àÂë
    £¨1£©µ¥×Ö½Ú7λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå128¸ö×Ö·û£¬×î³£ÓõÄ×Ö·û¼¯ÎªUS7ASCII
    £¨2£©µ¥×Ö½Ú8λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå256¸ö×Ö·û£¬ÊʺÏÓÚÅ·Ö޴󲿷ֹú¼Ò
    ÀýÈ磺WE8ISO8859P1(Î÷Å·¡¢8λ¡¢ISO±ê×¼8859P1±àÂë)
2.2.2 ¶à×Ö½Ú±àÂë
    £¨1£©±ä³¤¶à×Ö½Ú±àÂë
    Ä³Ð©×Ö·ûÓÃÒ»¸ö×Ö½Ú±íʾ£¬ÆäËü×Ö·ûÓÃÁ½¸ö»ò¶à¸ö×Ö·û±íʾ£¬±ä³¤¶à×Ö½Ú±àÂë³£ÓÃÓÚ¶ÔÑÇÖÞÓïÑÔµÄÖ§³Ö£¬   ÀýÈçÈÕÓï¡¢ººÓï¡¢Ó¡µØÓïµÈ
    ÀýÈ磺AL32UTF8£¨ÆäÖÐAL´ú±íALL,Ö¸ÊÊÓÃÓÚËùÓÐÓïÑÔ£©¡¢zhs16cgb231280
    £¨2£©¶¨³¤¶à×Ö½Ú±àÂë
    ÿһ¸ö×Ö·û¶¼Ê¹Óù̶¨³¤¶È×ֽڵıàÂë·½°¸£¬Ä¿Ç°oracleΨһ֧³ÖµÄ¶¨³¤¶à×Ö½Ú±àÂëÊÇAF16UTF16£¬Ò²ÊǽöÓÃÓÚ¹ú¼Ò×Ö·û¼¯
2.2.3 unicode±àÂë
    UnicodeÊÇÒ»¸öº­¸ÇÁËÄ¿Ç°È«ÊÀ½çʹÓõÄËùÓ


Ïà¹ØÎĵµ£º

oracle 10g ´íÎó ORA 01653 µÄ½â¾ö¹ý³Ì

ÔçÉÏÓû§·´Ó¦ÔÚ²Ù×÷ÓÃÓÑNCʱ±¨´í ORA-01653 £¬ÏêϸÐÅÏ¢£ºORA-01653: ±í NCV35.GL_DETAIL ÎÞ·¨Í¨¹ý 1024 (ÔÚ±í¿Õ¼ä NNC_DATA01 ÖÐ) À©Õ¹¡£
ÔÚÈÕÖ¾Îļþ F:\oracle\product\10.2.0\admin\CUTC\bdump\alert_cutc.logÖУ¬³öÏÖ
Thu Mar 04 10:59:21 2010
ORA-1653: unable to extend table NCV35.GL_DETAIL by 1024 in&nb ......

×Ô¼ºÐ´µÄoracle dbms_sql º¯Êý°üÀý×Ó

create or replace procedure pro_insert_dbms
is
cid number;
cid_DDL number;
selectsql varchar2(1000);
ddlsql    varchar2(1000);
row_count number;
nofrows   integer;
lrowid                & ......

Oracle´´½¨×ÔÔö×ֶη½·¨ ORACLE SEQUENCEµÄ¼òµ¥½éÉÜ

ÏȼÙÉèÓÐÕâôһ¸ö±í£º
create
 
table
 S_Depart  (
   DepartId             
INT
                   & ......

oracle 10.2.0.4 patchµÄÏÂÔصØÖ·Áбí

oracle 10.2.0.4 patchµÄÏÂÔصØÖ·Áбí
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://d ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ