Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µ±Ç°Á¬½ÓÊý

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

Êý¾Ý¿âÊÓͼ£¨oracle£©

ʹÓÃÊý¾Ý¿âÊÓͼͨ³£³öÓÚÒÔÏÂÁ½¸öÄ¿µÄ£º1¡£½µµÍ²Ù×÷¸´ÔÓ¶È£»ÊÓͼÊÇÔ¤±àÒëµÄ²éѯ²Ù×÷£¬Ò»´Î¶¨Ò壬֮ºó¿É¿ìËÙµ÷Óã»2¡£Ìá¸ßϵͳ°²È«¡£ÊÓͼ×÷ΪÊý¾Ý¿â¶ÔÏ󣬿ÉÒÔ½«ÆäȨÏÞ¶ÀÁ¢³öÀ´¸³¸øÓû§£¬¿É±ÜÃâÓû§¶Ô»ù±íµÄäĿΣÏÕ²Ù×÷£¬Í¬Ê±Ò²¿ÉÆÁ±ÎÒ»²¿·Ö˽ÃܵÄÊôÐÔÁС£
¶¨ÒåÓï¾ä£º
 CREATE
[OR REPLACE
]
[FORCE
|NOFORCE
......

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
[[ÓдíÎ󣿲»¿ ......

Oracle ÒÆ¶¯Êý¾ÝÎļþµÄ²Ù×÷·½·¨

½«±í¿Õ¼äºÍÊý¾ÝÎļþ´ÓÒ»¸öλÖÃÒÆ¶¯µ½ÁíÒ»¸öλÖõIJÙ×÷·½·¨
Ò»£® OFFLINE
OFFLINE ·ÖΪALTER DATABASE Óë ALTER TABLESPACE OFFLINE£¬
ËûÃǵÄÇø±ð²Î¿´blog£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/29/4898800.aspx
°´Êý¾ÝÎļþÀ´£º
1.ÏȽ«ÏàÓ¦µÄÊý¾ÝÎļþ offline 
ALTER DATABASE DATAFILE 'D:\OR ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ