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


Ïà¹ØÎĵµ£º

PL/SQLʵÏÖOracleÊý¾Ý¿âÈÎÎñµ÷¶È

 
     Ñ¡Ôñ×Ô softj µÄ Blog
¹Ø¼ü×Ö
  PL/SQLʵÏÖOracleÊý¾Ý¿âÈÎÎñµ÷¶È
³ö´¦
 
 
PL/SQLʵÏÖOracleÊý¾Ý¿âÈÎÎñµ÷¶È
¡¡¡¡¹Ø¼ü´Ê£ºÊý¾Ý»Ö¸´£¬ÈÎÎñµ÷¶È£¬ORACLE£¬PL/SQL
¡¡¡¡ÔÚÊý¾Ý¿â²Ù×÷ÖÐʱ³£»áÓÐÕâÑùµÄÇé¿ö·¢Éú£¬ÓÉÓÚһʱµÄÊèºö¶øÎóɾ»òÎó¸ÄÁËÒ»Ð©ÖØÒªµÄÊý¾Ý£¬ÁíÍ⻹ÓÐ ......

oracleÁÐתÐз½·¨×ܽá

·½·¨Ò»£º
----------------------------------------------------------------
---Muti-row to line(col2row)
----------------------------------------------------------------
create or replace type str_tab is table of varchar2(20);
/
grant all on str_tab to public;
create public synonym str_tab for ......

¶ÁÈ¡oracleÖÐblog×Ö¶Î

 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
 String URL=dbmes.url;
 Connection con = DriverManager.getConnection(URL,dbmes.usrname,dbmes.pwd);
try{
// ×¼±¸Óï¾äÖ´ÐжÔÏó
 String bh=request.getParameter("dwmc");
 Statement stmt = con.createStatement() ......

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

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

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

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