Oracle Êý¾Ý¿â ÊÂÎñ´¦Àí»ù±¾ÔÀí
ÊÂÎñ´¦Àí£ºËùνµÄÊÂÎñ´¦Àí¾ÍÊDZ£Ö¤²Ù×÷µÄÍêÕûÐÔ£¬ËùÓвÙ×÷Ҫôͬʱ³É¹¦£¬ÒªÃ´Í¬Ê±Ê§°Ü¡£
ÔÀíÈçÏ£º
ÔÚOracleÿ¸öÁ¬½Óµ½Êý¾Ý¿âµÄ´°¿Ú£¬Á¬½ÓÖ®ºó½¨Á¢Ò»¸ösession¡£Ò»¸ösessionÀïÃæ¶ÔÊý¾ÝËù×öµÄÐ޸ģ¬²»»áÁ¢¿Ì·´Ó¦ÔÚÊý¾Ý¿âµÄÕæʵÊý¾ÝÖ®ÉÏ£¬ÊÇÔÊÐí»Ø¹öµÄ£¬µ±Ò»¸ösessionÌá½»ËùÓеIJÙ×÷ºó£¬Êý¾Ý²ÅÕæÕýµØ×ö³öÐ޸ġ£
Á½¸öÊÂÎñ²Ù×÷£º
Ìá½»£ºcommit
»Ø¹ö£ºrollback
CommitºóÊý¾ÝÎÞ·¨»Ø¹ö¡£
ËÀËø£ºÒ»¸ösessionÀïÃæ¶ÔijÐÐÊý¾Ý½øÐиüвÙ×÷£¬Èç¹ûûÓÐcommit,ÄÇôÁíÍâÒ»¸ösessionÕë¶ÔÕâÐÐÊý¾ÝµÄ¸üн«ÐèÒªµÈ´ý£¬Ö±µ½µÚÒ»¸ösession commitºó£¬²ÅÌá½»¸üÐÂÊý¾Ý¡£
Ïà¹ØÎĵµ£º
ÈÕÇ°Óöµ½Ò»¸öÎÊÌ⣬ÐèÒª¶ÔÔÚOracleÊý¾Ý¿âÖвéѯ³öÀ´µÄÊýÖµ½øÐбÈÂʵļÆËã¡£ÀàËÆÓÚÈçϵÄSQL£º
Select Round((discount/Amount),2) from dual;
ÕâÑùËã³öÀ´µÄÊý×Ö¿ÉÒÔÂú×ã¾ø´ó²¿·ÖµÄÐèÇó¡£µ«ÊǶÔÓÚ²»µ½1µÄÊý×Ö£¬ÎÊÌâ³öÀ´ÁË......ÏÔʾµÄÀàËÆÓÚ .45Ñù×ÓµÄÊý¾Ý¡£0.45Ç°ÃæµÄ0²»¼ûÁË¡£
ÒÔÏÂ×ܽáÁËÁ½ÖÖ·½·¨À´½â¾öȱ0µÄÎÊÌâ¡£
µÚ ......
SELECT ID,
col_name,
SUBSTR(col_name, 1, INSTR(col_name || ',', ',', 1, 1) - 1) C1,
SUBSTR(col_name,
......
ÉîÈëÁ˽âOracle SCN (1)
--------------------------------------------------------------------------------
£Û˵Ã÷£Ý±¾À´ÔÚÑо¿Backup and Recovery£¬¿ÉÊÇÔÚ×öʵÑéµÄʱºòÓöµ½Ò»Ð©ÎÊÌâ²»ÊǺÜÀí½â£¬½ø¶ø×·¸ùÇóÔ´£¬Ïë¸ãÇå³þ£¬ÓÚÊDZØÐë¸ãÇå³þSCNºÍRecoveryÖ®¼äµÄ¹Øϵ¡£ÓÚÊǺõת¶øÑо¿SCN£¬ÕâÁ½Ìì¿´Á˺ܶàÎÄÕ£¬°üÀ¨EygleÍ ......
--´´½¨Óû§
create user iagent identified by ia
profile default
default tablespace users
temporary tablespace temp
account unlock;
--¸ø´´½¨µÄÓû§ÊÚȨ
grant create user,drop user,alter user,create any view,drop any view,exp_full_database,imp_full_database,dba,connect,resour ......