Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»Í£»úµÄ»° ,Ò²¿ÉÒÔ²ÉÓÃÔÚÏßÖØ¶¨Ò巽ʽÀ´×ö
ÒÔÏÂÊǽű¾:
alter table tb_test add permile_temp number;
Add/modify columns
alter table tb_test modify PERMILE null;
update tb_test set permile_temp=permile,permile=null;
commit;
alter table tb_test modify permile number(5,2);
update tb_test set permile=permile_temp,permile_temp=null;
commit;
alter table tb_test drop column permile_temp;
alter table tb_test modify PERMILE not null;
select * from tb_test ;


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle weblogic v10.3 configure JNDI

Step 1: log on admin portal
Step 2: select menu 'Services' - 'JDBC' - 'Data Source' and click New button to create a new data source
Step 3 : specify jndi name ad database
Step 4 : click Next button to set transaction properties
Step 5 : define connection properties
 
Step 6 : test databa ......

OracleµÄschema,user

ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵ͍Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in the database that can connect to and access objects.
Schemas and users help database ......

¶ÔoracleÖеÄBLOBµÄ²Ù×÷(¶ÁÈ¡£¬Ð´Èë)

 ½«BLOB±£´æÎª±¾µØÎĵµ£º
/// <summary>
/// ¶Á³öBlob×Ö¶Î
/// </summary>
/// <param name="commandText">sqlÓï¾ä£¬Ö´Ðнá¹ûΪBLOBÊý¾Ý</param>
/// <param name="DocumentAddress">½«Òª°ÑBLOBÊý¾Ý±£´æÎªµÄÎĵµµÄ·¾¶</param>
......

oracle pfileºÍspfileС½á

1¡¢pfile Îı¾Îļþ client¶Ë²ÎÊýÎļþ£»²»Äܶ¯Ì¬Ð޸ģ¬¿ÉÒÔÓÃÆÕͨµÄ±à¼­Æ÷Ð޸ģ¬ÐÞ¸ÄÖ®ºóÐèÒªÖØÆô¡£pfile¿ÉÄܻᵼÖ·þÎñÆ÷Æô¶¯²»Ò»Ö£¬ÒòΪ¿ÉÒÔÔÚ¿Í»§¶ËÆô¶¯¡£ 2¡¢spfile ¶þ½øÖÆÎļþ·þÎñÆ÷¶Ë²ÎÊýÎļþ£¬ÓÐÁËspfile£¬oracle¿ÉÒÔʵÏÖ¶¯Ì¬²ÎÊýÔÚÏßÐ޸쬲¿·Ö²ÎÊýÐÞ¸ÄÖ®ºóÎÞÐèÖØÆô¡£µ«ÊÇ£¬ÒòΪÊǶþ½øÖÆÎļþ£¬ËùÒÔ²»ÄÜÓÃÆÕͨµÄ±à¼­ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ