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

OracleÖÐÅúÁ¿µ¼³öSequence

 Ê¹ÓÃexp¹¤¾ß£¬ÒÔtablesµÄÀàÐ͵¼³öij¸öÓû§ÏÂËùÓеıíºÍÊý¾Ý£¬·¢ÏÖÆäÖÐsequenceûÓб»µ¼³ö¡£ÍøÉÏËÑË÷Ö®£¬·¢ÏÖtoadÃ²ËÆÓд˹¦ÄÜ£¬ÓÚÊǰ²×°ÁË9.6.1.1°æ±¾£¬½á¹û¾ÓȻû·¢Ïִ˹¦ÄÜ¡££¨¿ÉÄÜÊÇÎÒûÕÒµ½£¬ÖÁÉÙºÍÄÇλÀÏ´óµÄ½ØÍ¼²»Í¬£©£¬×îºóÕÒµ½ÈçϽű¾£¬¿ÉÒÔ½«Ä³¸öÓû§µÄÈ«²¿sequence²éѯ³öÀ´£¬²¢Æ´³É´´½¨Óï¾ä¡£
´úÂëÈçÏ£º
Java´úÂë
select 
'create sequence '
||sequence_name||
  
       
' minvalue '
||min_value||   
       
' maxvalue '
||max_value||   
       
' start with '
||last_number||   
       
' increment by '
||increment_by||   
       (
case
 when cache_size=
0
 then 
' nocache'
 
else
 
' cache '
||cache_size end) ||
';'
  
from dba_sequences where sequence_owner=
'HR'
  
select 'create sequence '||sequence_name||
' minvalue '||min_value||
' maxvalue '||max_value||
' start with '||last_number||
' increment by '||increment_by||
(case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'
from dba_sequences where sequence_owner='HR'
×¢Ò⣺ÆäÖеÄHR£¬ÊÇÐèÒªµ¼³ösequenceµÄÓû§£¬Ã²ËƱØÐë´óдµÄ˵£¡²¢ÇÒʹÓøýű¾µÄÓû§ÐèÒªÓзÃÎÊdba_sequencesµÄȨÏÞ¡£
µ¼³ö½á¹ûÈçÏ£º
Java´úÂë
create sequence HIBERNATE_SEQUENCE minvalue 
1
 maxvalue 
999999999999999999999999999
 start with 
1
 increment by 
1
 cache 
20
;
  
create sequence MIAGENTVERSION_VERSION_SEQ minvalue 
1
 maxvalue 
999999999999999999999999
 start with 
121
 increment by 
1
 cache 
20
;&nbs


Ïà¹ØÎĵµ£º

Oracle Ðм¶ËøµÄ¿ªÏú

Ê×ÏÈÀ´¸´Ï°Ò»ÏÂÐм¶ËøµÄ»úÖÆ¡£µ±Ò»¸öÊÂÎñ¿ªÊ¼Ê±±ØÑ¡ÏÈÉêÇëÒ»¸öTXËø£¨±£»¤»Ø¹ö¶Î¡¢»Ø¹öÊý¾Ý¿é£©£¬Ö»ÓÐÏÈÉêÇëµ½»Ø¹ö¶Î×ÊÔ´ºó²ÅÄÜ¿ªÊ¼Ò»¸öÊÂÎñ£¬²ÅÄܽøÐÐDML²Ù×÷¡£Õâ¸ö¶¯×÷Íê³Éºó£¬ÊÂÎñ¾Í¿ÉÒÔ¿ªÊ¼ÐÞ¸ÄÊý¾ÝÁË¡£µ±ÐÞ¸ÄÊý¾Ý±íµÄ¼Ç¼ʱ£¬×ñÑ­ÒÔϵIJÙ×÷˳Ðò¡£
1.»ñµÃ±íµÄTMËø£¨±£»¤ÊÂÎñÖ´Ðйý³ÌÖÐÆäËüÓû§²»ÄÜÐ޸ıí½á¹¹£©
2.ÔÚ ......

linuxÖÐoracleµÄÈÕ³£Î¬»¤ÃüÁî

1.  ¼ì²éOracleµÄ½ø³Ì
$  ps -ef|grep "ora_"|grep -v grep
  oracle  5998     1  0 11:15:59 ?        0:01 ora_j000_PPRD10
  oracle  2968     1  ......

oracle±Ê¼Ç

½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.3£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
SQL ÓïÑÔ·ÖÀࣺ
1  DDL£¨Êý¾Ý¶¨Òå £©ÓÃÓÚ´´½¨ºÍ¶¨ÒåÊý¾Ý¿â¶ÔÏ󣬲¢ÇÒ½«¶ÔÕâЩ¶ÔÏóµÄ¶¨Òå±£´æÔÚÊý¾Ý×ÖµäÖС£
creat  table     ´´½¨±í
alter  table     ÐÞ¸ ......

¶ÔOracleѧϰÕßµÄһЩ½¨Òé

ѧϰOracleÊÇÒ»¸öÂþ³¤¼è
ÐÁµÄ¹ý³Ì¡£Èç¹ûûÓÐÐËȤ£¬Ö»ÊDZ»ÆÈѧϰ£¬ÄÇôÊǺÜÄÑѧºÃµÄ¡£Ñ§Ï°µ½Ò»¶¨³Ì¶ÈµÄʱºò£¬ÒªÏë½øÒ»²½Ìá¸ß£¬¾Í²»µÃ²»½Ó´¥ºÜ¶àOracleÖ®ÍâµÄ¶«Î÷£¬Èç
Unix£¬ÈçÍøÂç¡¢´æ´¢µÈ¡£Òò´Ë£¬ÒªÕæµÄ¾öÐÄѧºÃOracle£¬¾ÍÒ»¶¨ÒªÓÐÐËȤ¡£ÓÐÁËÐËȤ£¬¾Í»áÒ»ÇбäµÃ¼òµ¥¿ìÀÖÆðÀ´¡£¼òµ¥×ܽáһϣ¬ÄǾÍÊÇ£ºÐËȤ¡¢Ñ§
ϰ¡¢Êµ¼ù¡£ ......

Oracle:²éÕÒ±íµÄÖ÷¼ü£¬Íâ¼ü£¬Î¨Ò»ÐÔÔ¼Êø£¬Ë÷Òý

1¡¢²éÕÒ±íµÄËùÓÐË÷Òý£¨°üÀ¨Ë÷ÒýÃû£¬ÀàÐÍ£¬¹¹³ÉÁУ©£º
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = Òª²éѯµÄ±í
2¡¢²éÕÒ±íµÄÖ÷¼ü£¨°üÀ¨Ãû³Æ£¬¹¹³ÉÁУ©£º
select cu.* from user_cons_columns cu, user_con ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ