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

oracle ´¥·¢Æ÷¿ª·¢

 ´¥·¢Æ÷¿ª·¢µÄÄ¿µÄ£ºÈ·±£Êý¾Ý¿âÂú×ãÌØ¶¨µÄÉÌÒµ¹æÔòºÍÆóÒµÂß¼­£¬¿ÉÒÔʹÓô¥·¢Æ÷£¬Ô¼Êø£¬×Ó³ÌÐò¡£ÒòΪ
   Ô¼Êø×î¼òµ¥ÇÒÐÔÄܺã¬ËùÑ¡Ô¼Êø£¬Èç¹ûÔ¼Êø²»ÄÜÂú×㣬¾ÍÓô¥·¢Æ÷£¬Èô´¥·¢Æ÷¶¼²»ÄÜÂú×ãÑ¡Ôñ×Ó³ÌÐò¡£
  
   Ò»¡¢´¥·¢Æ÷¹¦ÄÜ£º
   1£¬¿ØÖÆÊý¾Ý°²È«,ÔÚ·þÎñÆ÷¼¶±ð¿ØÖÆÊý¾Ý°²È«ÊÇͨ¹ýÊÚȨºÍ»ØÊÕ¶ÔÏóȨÏÞÀ´Íê³ÉµÄ£¬±ÈÈçamsÓû§¶Ôscott/tiger Óû§¶Ô±íDML ²Ù×÷¡¢
   grant select ,delete,update,insert on emp to ams;
   µ«ÊÇΪÁËʵÏÖ¸ü¸´Ôӵݲȫģʽ£¬±ÈÈçÏÞÖÆ¶Ôij¸ö±íÒªÐ޸ĵÄÊý¾Ý£¬¾ÍÐèÒªÓõ½´¥·¢Æ÷£¬±ÈÈ磬ֻÓÐÔÚ9£º00µ½17£º00²ÅÄܸıäÊý¾Ý¿âEMP±í¶ÔÊý¾Ý¿â±í²Ù×÷
   create or replace trigger triger_stat_before
    before insert or update or delete on emp
    
    declare
    -- local variables here
    begin
     if (to_char(sysdate,'HH24') not between '9' and '17') then
       RAISE_APPLICATION_ERROR(-20101,'·Ç¹¤×÷ÈÕʱ¼ä');
     end if;
   end triger_before;
   2£¬ÊµÏÖÊý¾ÝÉ󼯣¬¼àÊÓ·Ç·¨ºÍ¿ÉÒɵÄÊý¾Ý»î¶¯£¬oracle ±¾ÉíÌṩÁËÉ󼯹¦ÄÜ¡£Èç¶Ôemp DML ²Ù×÷ÒÔºó£¬
   °ÑSQL²Ù×÷µÄÐÅÏ¢(Óû§£¬Ê±¼äµÈ)дÈë×ֵ䡣µ«ÊÇÖ»ÄÜÉó¼Æsql ²Ù×÷£¬²»ÄܼÇÔØÊý¾Ý±ä»¯¡£Èç¹ûÒª¼ÇÔØÊý¾Ý
   ±ä»¯±ØÐëʹÓÃDML´¥·¢Æ÷¡£±ÈÈ繤×ʱ仯дÈëÊý¾Ý×Öµä±í¡£
   --´´½¨×Öµä±í
      drop table EMP_CHANGE;
   create table EMP_CHANGE(
    CNAME       VARCHAR2(200),
    OLDSAL      NUMBER,
    NEWSAL      NUMBER,
    CHANGE_TIME TIMESTAMP(6)
   )
  --´´½¨´¥·¢Æ÷
  create or replace trigger triger_row_after
   after update of sal  on emp 
   for each row
 


Ïà¹ØÎĵµ£º

oracle·þÎñÆ÷ÅäÖü°ÓÅ»¯

1.ÔÚORACLEÖÐʵÏÖ·Ö²¼Ê½¿ìËÙ´æÈ¡ºÍ³äʵÄÚ´æÊǺÜÖØÒªµÄ¡£
¡¡¡¡
¡¡¡¡Òª²»Ï§Èκδú¼Û±ÜÃâÒ³Ãæµ÷¶ÈºÍ½»»»﹐ÿ´Î¶¼±ØÐë°Ñϵͳȫ¾ÖÇø(SGA)·Åµ½ÄÚ´æ¡£
¡¡¡¡
¡¡¡¡½«SGA·Åµ½ÄÚ´æÖÐ﹐ÔÚINIT.ORAÖÐÉèÖòÎÊý PRE_PAGE_SGA
¡¡¡¡
¡¡¡¡PRE_PAGE_SGA=YES
¡¡¡¡
¡¡¡¡2.»Ø¾í¶ÎµÄ¾¹Õù»á½µµÍϵͳµÄÐÔÄÜ¡£
¡¡¡¡
¡¡¡¡SELECT¡ ......

oracle³£Óþ­µäSQL²éѯ£¨×ªÔØ£©

³£ÓÃSQL²éѯ£º
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
select tablespace_name, file_id, ......

java²Ù×÷oracleÊý¾Ý¿âÖеÄblob×Ö¶Î

oracleÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.R ......

C#´¦Àíoracle lobµÄÀý×Ó

  protected void BindData1()
    {
        OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        orcn.Open();
      &nb ......

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ