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

oracle ÐÞ¸Ä×Ö¶ÎÀàÐ͵ķ½·¨

½ñÌ칫˾ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter   table  tb_test  modify permile  number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set  permile_temp=permile;
alter table drop column permile;
alter  table test rename column  permile_temp to permile;
ÕâÖÖ·½·¨»áʹÁÐÃû·¢Éú±ä»¯,¶øÇÒ×Ö¶Î˳ÐòÔö¼Ó ÓпÉÄÜ·¢ÉúÐÐÇ¨ÒÆ,¶ÔÓ¦ÓóÌÐò»á²úÉúÓ°Ïì
ÒÔÏ·½·¨ÊDZȽϺõķ½·¨
²»ÓÃʹÁÐÃû·¢Éú±ä»¯ Ò²²»»á·¢Éú±íÇ¨ÒÆ,µ«Õâ¸öÓиöȱµãÊDZíÒª¸üÐÂÁ½´Î
Èç¹ûÊý¾ÝÁ¿½Ï´óµÄ»° ²úÉúµÄundoºÍredo¸ü¶à ,ǰÌáÒ²ÊÇҪͣ»ú×ö
ÒªÊDz»Í£»úµÄ»° ,Ò²¿ÉÒÔ²ÉÓÃÔÚÏßÖØ¶¨Ò巽ʽÀ´×ö 
ÒÔÏÂÊǽű¾:
-- Ìí¼ÓÒ»¸öÁÙʱÁÐpermile_temp ÀàÐÍΪ number
alter table tb_test  add permile_temp number;
-- ÉèÖÃÒª¸Ä¶¯µÄÁÐpermile ¿ÉÒÔΪNULL
alter table  tb_test  modify  permile null;
-- °Ñpermile ÁеÄֵȫ²¿¸üиøÁÙʱÁÐpermile_temp£¬È»ºó°Ñ permile ¸üÐÂΪNULL
update  tb_test  set permile_temp=permile,permile=null;
commit;
-- °ÑÁÐÄ¿±êÁÐ permile Êý¾ÝÀàÐ͸Ķ¯Îªnumber(5,2)
alter table  tb_test  modify permile number(5,2);
-- °Ñpermile ÁеÄֵȫ²¿¸üлØÀ´£¬È»ºó°Ñ ÁÙʱÁÐ ¸üÐÂΪNULL
update  tb_test  set permile=permile_temp,permile_temp=null;
commit;
 -- ×îºóɾ³ýÌí¼ÓµÄÁÙʱÁÐ
alter table  tb_test  drop column permile_temp;
-- ×îºó»¹Ô­ÁÐ permile ²»ÔÊÐíΪNULL
alter table  tb_test  modify permile not null;
select * from  tb_test ;
 
 


Ïà¹ØÎĵµ£º

oracleµÄ×óÓÒÁ¬½Ó

¶Ô×óÁ¬½Ó¡¢ÓÒÁ¬½ÓµÄÒÉ»óµÃµ½½â¾ö¡£
ÔÚOracle PL-SQLÖУ¬×óÁ¬½ÓºÍÓÒÁ¬½ÓÒÔÈçÏ·½Ê½À´ÊµÏÖ
²é¿´ÈçÏÂÓï¾ä£º
SELECT emp_name, dept_name
FORM Employee, Department
WHERE Employee.emp_deptid(+) = Department.deptid
      ´ËSQLʹÓÃÁËÓÒÁ¬½Ó£¬¼´“(+)”ËùÔÚλÖõÄÁíÒ»²àΪÁ¬½Óµ ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî

--ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ£¿
 2006/2/16 zhanghua first create                            
     Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚora ......

oracle 10g OCPÈÏÖ¤

     µÍ³É±¾»ñÈ¡OracleÏà¹ØÈÏÖ¤£¬È«Ãæ¿ìËÙÕÆÎÕOracle¼¼Êõ
  
ÔÚÆóҵȺÌåÖУ¬È«Çò500Ç¿£¬ÓÐ98%ÔÚʹÓÃOracle¼¼Êõ£»È«ÇòÊ®´óÒøÐоù²ÉÓÃÁËOracleÓ¦ÓÃϵͳ£¬ÔÚÖйú£¬ÅÅÃûǰ20λµÄÒøÐж¼ÔÚʹÓÃOracle¼¼Êõ£»ÔÚͨÐÅÁìÓò£¬È«Çò20¼Ò¶¥¼¶Í¨ÐŹ«Ë¾È«²¿¶¼ÔÚʹÓÃOracleÓ¦ÓòúÆ·¡£ÔÚÖйú£¬ËùÓеĵçÐÅÓªÔËÉ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ