Oracle×Ö·û¼¯²âÊÔ
ÒÔÏ»شðÊôÓÚתÔØ£º
¾³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨ËùÒÔ½Ð×ö"¼ÆËã»ú"£©£¬µ«Ëæ׿¼ÊõµÄ·¢Õ¹£¬»¹ÐèÒª¼ÆËã»ú½øÐÐÆäËü·½ÃæµÄÓ¦Óô¦Àí¡£Õâ¾ÍÒªÇó¼ÆËã»ú²»½öÄÜ´¦ÀíÊýÖµ£¬»¹ÄÜ´¦ÀíÖîÈçÎÄ×Ö¡¢ÌØÊâ·ûºÅµÈÆäËüÐÅÏ¢£¬¶ø¼ÆËã»ú±¾ÉíÄÜÖ±½Ó´¦ÀíµÄÖ»ÓÐÊýÖµÐÅÏ¢£¬ËùÒÔ¾ÍÒªÇó¶ÔÕâЩÎÄ×Ö¡¢·ûºÅÐÅÏ¢½øÐÐÊýÖµ±àÂ룬×î³õµÄ×Ö·û¼¯ÊÇÎÒÃǶ¼·Ç³£ÊìϤµÄASCII£¬ËüÊÇÓÃ7¸ö¶þ½øÖÆλÀ´±íʾ128¸ö×Ö·û£¬¶øºóÀ´Ëæ×Ų»Í¬¹ú¼Ò¡¢×éÖ¯µÄÐèÒª£¬³öÏÖÁËÐíÐí¶à¶àµÄ×Ö·û¼¯£¬Èç±íʾÎ÷Å·×Ö·ûµÄISO8859ϵÁеÄ×Ö·û¼¯£¬±íʾºº×ÖµÄGB2312-80¡¢GBKµÈ×Ö·û¼¯¡£
×Ö·û¼¯µÄʵÖʾÍÊǶÔÒ»×éÌض¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬµÄÊýÖµ±àÂ룬ÒÔ±ãÓÚ¼ÆËã»úµÄ´¦Àí¡£
×Ö·û¼¯Ö®¼äµÄת»»¡£×Ö·û¼¯¶àÁË£¬¾Í»á´øÀ´Ò»¸öÎÊÌ⣬±ÈÈçÒ»¸ö×Ö·û£¬ÔÚijһ×Ö·û¼¯Öб»±àÂëΪһ¸öÊýÖµ£¬¶øÔÚÁíÒ»¸ö×Ö·û¼¯Öб»±àÂëΪÁíÒ»¸öÊýÖµ£¬±ÈÈçÎÒÀ´´´ÔìÁ½¸ö×Ö·û¼¯demo_charset1Óëdemo_charset2£¬ÔÚdemo_charset1ÖУ¬Îҹ涨ÁËÈý¸ö·ûºÅµÄ±àÂëΪ£ºA£¨0001£©£¬B£¨0010£©£¬£¿£¨1111£©£»¶øÔÚdemo_charset2ÖУ¬ÎÒÒ²¹æ¶¨ÁËÈý¸ö·ûºÅµÄ±àÂëΪ£ºA£¨1001£©£¬C£¨1011£©£¬£¿£¨1111£©£¬ÕâʱÎÒ½Óµ½Ò»¸öÈÎÎñ£¬Òª±àдһ¸ö³ÌÐò£¬¸ºÔðÔÚdemo_charset1Óëdemo_charset2Ö®¼ä½øÐÐת»»¡£ÓÉÓÚÖªµÀÁ½¸ö×Ö·û¼¯µÄ±àÂë¹æÔò£¬¶ÔÓÚdemo_charset1ÖеÄ0001£¬ÔÚת»»Îªdemo_charset2ʱ£¬Òª½«Æä±àÂë¸ÄΪ1001£»¶ÔÓÚdemo_charset1ÖеÄ1111£¬×ª»»Îªdemo_charset2ʱ£¬ÆäÊýÖµ²»±ä£»¶ø¶ÔÓÚdemo_charset1ÖеÄ0010£¬Æä¶ÔÓ¦µÄ×Ö·ûΪB£¬µ«ÔÚdemo_charset2ûÓжÔÓ¦µÄ×Ö·û£¬ËùÒÔ´ÓÀíÂÛÉÏÎÞ·¨×ª»»£¬¶ÔÓÚËùÓÐÕâÀàÎÞ·¨×ª»»µÄÇé¿ö£¬ÎÒÃÇ¿ÉÒÔ½«ËüÃÇͳһת»»ÎªÄ¿±ê×Ö·û¼¯ÖеÄÒ»¸öÌØÊâ×Ö·û£¨³ÆΪ"Ìæ»»×Ö·û"£©£¬±ÈÈçÔÚÕâÀïÎÒÃÇ¿ÉÒÔ½«£¿×÷ΪÌæ»»×Ö·û£¬ËùÒÔB¾Íת»»ÎªÁË£¿£¬³öÏÖÁËÐÅÏ¢µÄ¶ªÊ§£»Í¬ÑùµÀÀí£¬½«demo_charset2µÄC×Ö·ûת»»µ½demo_charset1ʱ£¬Ò²»á³öÏÖÐÅÏ¢¶ªÊ§¡£
ËùÒÔ˵£¬ÔÚ×Ö·û¼¯×ª»»¹ý³ÌÖУ¬Èç¹ûÔ´×Ö·û¼¯ÖеÄij¸ö×Ö·ûÔÚÄ¿±ê×Ö·û¼¯ÖÐûÓж¨Ò壬½«»á³öÏÖÐÅÏ¢¶ªÊ§¡£
Êý¾Ý¿â×Ö·û¼¯µÄÑ¡Ôñ¡£
ÎÒÃÇÔÚ´´½¨Êý¾Ý¿âʱ£¬ÐèÒª¿¼ÂǵÄÒ»¸öÎÊÌâ¾ÍÊÇÑ¡Ôñʲô×Ö·û¼¯Óë¹ú¼Ò×Ö·û¼¯£¨Í¨¹ýcreate databaseÖеÄCHARACTER SETÓëNATIONAL C
Ïà¹ØÎĵµ£º
Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄܹرջá¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......
Oracle LongÐÍ
1¡¢LONG Êý¾ÝÀàÐÍÖд洢µÄÊǿɱ䳤×Ö·û´®£¬×î´ó³¤¶ÈÏÞÖÆÊÇ2GB¡£
2¡¢¶ÔÓÚ³¬³öÒ»¶¨³¤¶ÈµÄÎı¾£¬»ù±¾Ö»ÄÜÓÃLONGÀàÐÍÀ´´æ´¢£¬Êý¾Ý×ÖµäÖкܶà¶ÔÏóµÄ¶¨Òå¾ÍÊÇÓÃLONGÀ´´æ´¢µÄ¡£
3¡¢LONGÀàÐÍÖ÷ÒªÓÃÓÚ²»ÐèÒª×÷×Ö·û´®ËÑË÷µÄ³¤´®Êý¾Ý£¬Èç¹ûÒª½øÐÐ×Ö·ûËÑË÷¾ÍÒªÓÃvarchar2ÀàÐÍ¡£
4¡¢ºÜ¶à¹¤¾ß£¬°üÀ¨SQL*Plus£¬´ ......
´¦Àí·½·¨Ò» £º
¼ì²éÄǸö±í±»Ëø
select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;
½âËø
alter system kill session '273,45';
´¦Àí·½·¨¶ ......
²éѯijÁÐֵΪnullµÄ¼Ç¼£º
select *
from tablename
where col is null;
²éѯijÁÐÖµ²»ÎªnullµÄ¼Ç¼£º
select *
from tablename
where col is not null;
Õë¶ÔnullµÄ+-*/=!=µÈ²Ù×÷¶¼ÊÇnull£º
null±íʾ²»È·¶¨µÄÖµ£¬Á½¸önull±íʾÁ½¸ö²»È·¶¨µÄÖµ¡¢Î´ÖªµÄÖµ£¬Òò´Ë²»´æÔÚÁ½¸önullµÄÏàµÈ£¬Í ......
delete ɾ³ýÒ»ÕÅ´ó±íʱ¿Õ¼ä²»ÊÍ·Å£¬·Ç³£ÂýÊÇÒòΪռÓôóÁ¿µÄϵͳ×ÊÔ´£¬Ö§³Ö»ØÍ˲Ù×÷£¬¿Õ¼ä»¹±»ÕâÕűíÕ¼ÓÃ×Å¡£
truncate table ±íÃû (ɾ³ý±íÖмǼʱÊͷűí¿Õ¼ä)
DML Óï¾ä£º
±í¼¶¹²ÏíËø£º ¶ÔÓÚ²Ù×÷Ò»ÕűíÖеIJ»Í¬¼Ç¼ʱ£¬»¥²»Ó°Ïì
Ðм¶ÅÅËüËø£º¶ÔÓÚÒ»ÐмǼ£¬oracle »áÖ»ÔÊÐíÖ»ÓÐÒ»¸öÓû§¶ÔËüÔÚͬһʱ¼ä½øÐÐÐ޸IJÙ×÷ ......