Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Æô¶¯ÃüÁî

1¡¢startup nomount
·Ç°²×°Æô¶¯£¬ÕâÖÖ·½Ê½Æô¶¯Ï¿ÉÖ´ÐУºÖؽ¨¿ØÖÆÎļþ¡¢Öؽ¨Êý¾Ý¿â¶ÁÈ¡init.oraÎļþ£¬Æô¶¯instance£¬¼´Æô¶¯SGAºÍºǫ́½ø³Ì£¬ÕâÖÖÆô¶¯Ö»ÐèÒªinit.oraÎļþ¡£
2¡¢startup mount dbname
°²×°Æô¶¯£¬ÕâÖÖ·½Ê½Æô¶¯Ï¿ÉÖ´ÐУº
Êý¾Ý¿âÈÕÖ¾¹éµµ¡¢
Êý¾Ý¿â½éÖʻָ´¡¢
ʹÊý¾ÝÎļþÁª»ú»òÍÑ»ú£¬
ÖØÐ¶¨Î»Êý¾ÝÎļþ¡¢Ö ......

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 ¶¨Ê±±¸·Ý

µÚÒ»²½£º н¨Îļþ“¶¨Ê±±¸·Ý.bat”£¬ ÎļþÄÚÈÝÈçÏ£º
set tempvalue=databaseName_%date:~0,10%
set directory_temp=d:\BackUp\%tempvalue%
set file_dmp=%directory_temp%\%tempvalue%.dmp
set file_log=%directory_temp%\%tempvalue%.log
set winrarPath="C:\Program Files\WinRAR\WinRAR.exe"
set file ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ