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

Oracle×Ö·û¼¯ÐÞ¸ÄÎÊÌâ

 ¾­³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝǨÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂǨÒÆʧ°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ÉÂÒÂë¡£ÏÖÔÚÎÒ½«oracle×Ö·û¼¯Ïà¹ØµÄһЩ֪ʶ×ö¸ö¼òµ¥×ܽᣬϣÍû¶Ô´ó¼Ò½ñºóµÄ¹¤×÷ÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØϵ¡£ORACLE Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ»¯ÓïÑÔºÍƽ̨¡£
¡¡¡¡Ó°ÏìoracleÊý¾Ý¿â×Ö·û¼¯×îÖØÒªµÄ²ÎÊýÊÇNLS_LANG²ÎÊý¡£ËüµÄ¸ñʽÈçÏÂ:
¡¡¡¡NLS_LANG = language_territory.charset
¡¡¡¡ËüÓÐÈý¸ö×é³É²¿·Ö(ÓïÑÔ¡¢µØÓòºÍ×Ö·û¼¯)£¬Ã¿¸ö³É·Ö¿ØÖÆÁËNLS×Ó¼¯µÄÌØÐÔ¡£ÆäÖÐ:
¡¡¡¡Language Ö¸¶¨·þÎñÆ÷ÏûÏ¢µÄÓïÑÔ£¬territory Ö¸¶¨·þÎñÆ÷µÄÈÕÆÚºÍÊý×Ö¸ñʽ£¬charset Ö¸¶¨×Ö·û¼¯¡£Èç:AMERICAN _ AMERICA. ZHS16GBK
¡¡¡¡´ÓNLS_LANGµÄ×é³ÉÎÒÃÇ¿ÉÒÔ¿´³ö£¬ÕæÕýÓ°ÏìÊý¾Ý¿â×Ö·û¼¯µÄÆäʵÊǵÚÈý²¿·Ö¡£ËùÒÔÁ½¸öÊý¾Ý¿âÖ®¼äµÄ×Ö·û¼¯Ö»ÒªµÚÈý²¿·ÖÒ»Ñù¾Í¿ÉÒÔÏ໥µ¼Èëµ¼³öÊý¾Ý£¬Ç°ÃæÓ°ÏìµÄÖ»ÊÇÌáʾÐÅÏ¢ÊÇÖÐÎÄ»¹ÊÇÓ¢ÎÄ¡£
¡¡¡¡¶þ¡¢ÈçºÎ²éѯOracleµÄ×Ö·û¼¯
¡¡¡¡ºÜ¶àÈ˶¼Åöµ½¹ýÒòΪ×Ö·û¼¯²»Í¬¶øʹÊý¾Ýµ¼Èëʧ°ÜµÄÇé¿ö¡£ÕâÉæ¼°Èý·½ÃæµÄ×Ö·û¼¯£¬Ò»ÊÇoracel server¶ËµÄ×Ö·û¼¯£¬¶þÊÇoracle client¶ËµÄ×Ö·û¼¯;ÈýÊÇdmpÎļþµÄ×Ö·û¼¯¡£ÔÚ×öÊý¾Ýµ¼ÈëµÄʱºò£¬ÐèÒªÕâÈý¸ö×Ö·û¼¯¶¼Ò»Ö²ÅÄÜÕýÈ·µ¼Èë¡£
¡¡¡¡1¡¢²éѯoracle server¶ËµÄ×Ö·û¼¯
¡¡¡¡ÓкܶàÖÖ·½·¨¿ÉÒÔ²é³öoracle server¶ËµÄ×Ö·û¼¯£¬±È½ÏÖ±¹ÛµÄ²éѯ·½·¨ÊÇÒÔÏÂÕâÖÖ:SQL>select userenv(‘language’) from dual;
¡¡¡¡½á¹ûÀàËÆÈçÏÂ:AMERICAN _ AMERICA. ZHS16GBK
¡¡¡¡2¡¢ÈçºÎ²éѯdmpÎļþµÄ×Ö·û¼¯
¡¡¡¡ÓÃoracleµÄexp¹¤¾ßµ¼³öµÄdmpÎļþÒ²°üº¬ÁË×Ö·û¼¯ÐÅÏ¢£¬dmpÎļþµÄµÚ2ºÍµÚ3¸ö×ֽڼǼÁËdmpÎļþµÄ×Ö·û¼¯¡£Èç¹ûdmpÎļþ²»´ó£¬±ÈÈçÖ»Óм¸M»ò¼¸Ê®M£¬¿ÉÒÔÓÃUltraEdit´ò¿ª(16½øÖÆ·½Ê½)£¬¿´µÚ2µÚ3¸ö×Ö½ÚµÄÄÚÈÝ£¬Èç0354£¬È»ºóÓÃÒÔÏÂSQL²é³öËü¶ÔÓ¦µÄ×Ö·û¼¯:
¡¡¡¡SQL> select nls_charset_name(to_number('0354','xxxx')) from dual;
¡¡¡¡ZHS16GBK
¡¡¡¡Èç¹ûdmpÎļþºÜ´ó£¬±ÈÈçÓÐ2GÒÔÉÏ(ÕâÒ²ÊÇ×î³£¼ûµÄÇé¿ö)£¬ÓÃÎı¾±à¼­Æ÷´ò¿ªºÜÂý»òÕßÍêÈ«´ò²»¿ª£¬¿ÉÒÔÓÃÒÔÏÂÃüÁî(ÔÚunixÖ÷»úÉÏ):
¡¡¡¡cat exp.dmp |od -x|head -1|awk '{print


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÃæÊÔÎÊÌ⼯ºÏ¼°¼¼ÇÉ

 
ÕâƪÎÄÕÂÊÇORACLEÃæÊÔµÄÎÊÌâ½õ¼¯£¬ËäÈ»²»È«Ã棬µ«ÊÇÕâƪÎÄÕ»áÈÃÄãÖªµÀÈçºÎÈÃÃæÊÔ¿¼¹ÙÁ˽âÄã¶ÔORACLE¸ÅÄîµÄÊìϤ³Ì¶È¡£
 
1.½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
 
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐÄ£Ê ......

oracle ±Ê¼Ç

 1. SQL  Óï¾äÓëSQL*Plus ÃüÁî
 
 SQL
SQL*Plus
Ò»ÖÖÓïÑÔ
Ò»ÖÖ»·¾³
ANSI±ê×¼
Oracle µÄÌØÐÔÖ®Ò»
¹Ø¼ü×Ö²»ÄÜËõд
¹Ø¼ü×Ö¿ÉÒÔËõд
ʹÓÃÓï¾ä¿ØÖÆÊý¾Ý¿âÖеıíµÄ¶¨ÒåÐÅÏ¢
ºÍ±íÖеÄÊý¾Ý
ÃüÁî²»ÄܸıäÊý¾Ý¿âÖеÄÊý¾ÝµÄÖµ
 
¼¯ÖÐÔËÐÐ
2.ÒÔϼ¸¸ö²éѯºÜÖØÒª£¬×ÐϸÌå»á
1  (ÓÐÔ±¹¤µÄ³ ......

ORACLE PL/SQL¿ª·¢

¸Õ¸ÕÔÚinthirtiesÀÏ´óµÄ²©¿ÍÀï¿´µ½ÕâƪÎÄÕ£¬Ð´µÄ²»´í£¬ÕýºÃ×Ô¼º×î½üÔÚѧϰPL/SQL£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°¡£
==================================================================================
bulk collectÊÇ¿ÉÒÔ¿´×öÊÇÒ»ÖÖÅú»ñÈ¡µÄ·½Ê½£¬ÔÚÎÒÃǵÄplsqlµÄ´úÂë¶ÎÀï¾­³£×÷ΪintoµÄÀ©Õ¹À´Ê¹Ó᣶ÔÓÚselect id into v from ... ......

oracle ±Ê¼Ç II Ö®DML:Êý¾Ý²Ù×÷ÓïÑÔ

 DML:Data Manipulation Language Êý¾Ý²Ù×÷ÓïÑÔ
°üÀ¨£ºCRUD
1. insertÓï¾ä
(1) ´ÓÆäËü±íÖи´ÖÆÊý¾Ý,ʵÏÖ·½·¨:ÔÚinsert Óï¾äÖмÓÈë²éѯÓï¾ä
insert into sales_reps(id,name,salary,commission_pct)  select employee_id,last_name,salary,commission_pct
from employees where job_id like '%rep';
(2) up ......

oracleÖе¥¼Ç¼º¯ÊýµÄ¹éÄÉ×ܽá

 SQLÖеĵ¥¼Ç¼º¯Êý
Ò»¡¢×Ö·ûº¯Êý
 
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
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ