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

 
Ò»¡¢Ñ¡ÔñÌâ
¡¡¡¡
¡¡¡¡1.µ±ÄãÖ´ÐÐÒÔϲéѯÓï¾ä:
¡¡¡¡SELECT empno,ename
¡¡¡¡from emp
¡¡¡¡WHERE empno =7782 OR empno =7876;
¡¡¡¡ÔÚWHEREÓï¾äÖУ¬ÒÔÏÂÄĸö²Ù×÷·û¿ÉÒÔÈ¡´úOR£¿
¡¡¡¡A. IN
¡¡¡¡B. BETWEEN ……
¡¡¡¡C. LIKE
¡¡¡¡D. <=
¡¡¡¡E. >=
¡¡¡¡
¡¡¡¡2. ÄĸöʵÏÖ  ......

Ãâ°²×°µÄOracle¿Í»§¶Ë

 Oracle Instant ClientÊÇÃâ°²×°µÄOracle¿Í»§¶Ë£¬ÓÉÓÚËüûÓб»OracleµÄ°²×°³ÌÐòËù·â×°£¬Ê¹Óû§¸üÈÝÒ×Àí½âËüµÄ½á¹¹¡£
Instant Client¼ò½é
ÔÚÆä×îеÄVersion 11.1.0.7.0ÖУ¬°üÀ¨ÏÂÃæµÄ°ü£º
µÚÒ»¡¢»ù±¾°ü¡£
ÓÐÁ½ÖÖ£ºÈ«¹¦ÄܰüºÍ¼ò»¯°ü£¬¸ù¾ÝÐèÒªÏÂÔØ¡£
1)  Instant Client Package - Basic: All files required ......

oracle ÐèҪעÒâµÄµØ·½

INSERT /*+APPEND */ INTO employee (empno,ename,sal,deptno)
SELECT empno,ename,sal,deptno from emp
WHERE deptno=20;
µÚ¶þÌõÓï¾äʹÓÃ/*+APPEND */À´±íʾ²ÉÓÃÖ±½Ó×°ÔØ·½Ê½£¬µ±Òª×°ÔØ´óÅúÁ¿Êý¾Ýʱ£¬²ÉÓõڶþÖÖ·½·¨×°ÔØÊý¾ÝµÄËÙ¶ÈÒªÔ¶Ô¶ÓÅÓÚµÚÒ»ÖÖ·½·¨¡£
ʹÓöà±í²åÈëÊý¾Ý
ʹÓÃALL²Ù×÷·ûÖ´Ðжà±í²åÈëʱ£¬ÔÚÿ¸öÌõ¼þ× ......

oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç

oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º     
Code
create [or replace] procedure procedure_name
  [(argument[{in|out|in out}] type,
    
   argument[{in|out|in out}] type)]&n ......

WindowsXPÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â

 ³ö´¦£ºhttp://hi.baidu.com/vcy168/blog/item/877945d908c3d52611df9ba0.html
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ