Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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;


Ïà¹ØÎĵµ£º

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×Ô´øµÄ²Ù×÷ÎļþµÄ°üUTL_FILE½éÉÜ

    Òò¿ª·¢ÒªÇó£¬ÐèÒª¶ÔoracleÀïµÄÊý¾ÝÓëÊý¾ÝÎļþ×÷±È½Ï¡£Èç²ÉÓÿͻ§¶ËÁ¬½ÓoracleµÄ·½Ê½ÔòÏÔµÃСÌâ´ó×ö£¬ÇÒ¹¤×÷Á¿´ó£¬²»Ò×ά»¤¡£Ö±½Ó²ÉÓô洢¹ý³Ì£¬µ÷ÓÃUTL_FILE°üµÄ¹«¹²¹ý³Ì£¬ÏԵ÷½±ãµÃ¶à¡£
    Ê×ÏÈ£¬ÐèÒª°ÑÊý¾ÝÎļþËùÔÚµÄĿ¼ע²áµ½oracleÖУ¬ÓÃcreate directory¡£¡£¡£Óï¾ä£¬È»ºó°Ñ´ËÄ¿ ......

Ubuntu°²×°OracleºóÔËÐÐSqlplus±¨´íµÄ½â¾ö°ì·¨

µ±ÔËÐÐsqlplus.shµÄʱºò±¨³ö£º
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
ºÜÆæ¹Ö
nls_lang.shµÄ114ÐÐÇ°ºóÊÇÕâÑùµÄ
if [[ -n "$LC_ALL" ]]; then
  locale=$LC_ALL
elif [[ -n "$LANG" ]]; then
  locale=$LANG
else
  locale=
fi
[[ÓдíÎ󣿲»¿ ......

Oracle10g r1ÔÚLINUX OS4Éϵݲװ

°²×°oralce10g R1(10.1)²½Öè·½·¨£º
µÚÒ»²¿·Ö£º
Ò».  Ó²¼þ»·¾³£º
   1. RAM£ºÖÁÉÙ512M
    2.  ½»»»·ÖÇø´óСÖÁÉÙ1G£¨»òÕßÊÇÄÚÔÚµÄ2±¶£©
   3./tmpĿ¼ ÖÁÉÙÓÐ400M¿ÕÏпռä
   4. oracleÈí¼þ°²×°¿Õ¼äÖÁÉÙÔÚ1.5G--3GÖ®¼ä£¨ÒÀ¾Ý°²×°oracleÀàÐͶø¶¨£©
 &nbs ......

[ת]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ºÅ