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

oracle sequenceÖµÖØÖûØ1

declare 
  n   number(10); 
  tsql   varchar2(100); 
  begin 
  select   test_seq.nextval   into   n   from   dual; 
  n:=-(n-1); 
  tsql:='alter   sequence   test_seq   increment   by'||   n; 
  execute   immediate   tsql; 
  select   test_seq.nextval   into   n   from   dual; 
  tsql:='alter   sequence   test_seq   increment   by   1'; 
  execute   immediate   tsql; 
  end;


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

²éѯoracleµ±Ç°Á¬½ÓÊý

   ÎÒÃǼÙÉèÊÇÊý¾Ý¿â¹ÜÀíÔ±£¬ÎªÁËÊý¾Ý¿âµÄ°²È«£¬ÎÒÃÇÐèÒªÖªµÀµ±Ç°ÓжàÉÙÁ¬½ÓÊý£¬×î´óÖ§³Ö¶àÉÙÁ¬½ÓÊý£¬¿ÉÒÔÓÃÒÔÏÂÓï¾ä²éѯ
      select username,count(username),machine,status from v$session         
    &n ......

ORACLE´¥·¢CHECKPOINTµÄÌõ¼þ~

ORACLE´¥·¢CHECKPOINTµÄÌõ¼þ
1.µ±·¢ÉúÈÕÖ¾×éÇл»µÄʱºò
2.µ±·ûºÏLOG_CHECKPOINT_TIMEOUT£¬LOG_CHECKPOINT_INTERVAL£¬fast_start_io_target,fast_start_mttr_target²ÎÊýÉèÖõÄʱºò
3.µ±ÔËÐÐALTER SYSTEM SWITCH LOGFILEµÄʱºò
4.µ±ÔËÐÐALTER SYSTEM CHECKPOINTµÄʱºò
5.µ±ÔËÐÐalter tablespace XXX begin backup£¬e ......

[ת]Oracle,sql serverµÄ¿ÕÖµ(null)ÅжÏ


sql server
Ìæ»»null:isnull(arg,value)
Èç:select isnull(price,0.0) from orders                             ,Èç¹ûpriceΪnullµÄ»°£¬ÓÃ0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ