°ïÎÒÓÃOracle½¨¸ö¿â°É~
ÀïÍ·ÓÐÁ½ÕÅ±í£º
1. ±íÃûÊÇview_jbpm_users,¹²ÓÐ
empid(varchar2(100)),name(varchar2(100)),account(varchar2(100)),deptid(varchar2(100)),deptname(varchar2(100)),roleid(varchar2(100)),rolenamne(varchar2(100))ÕâÆß¸ö×ֶΡ£
2. ±íÃûÊÇview_jbpm_org, ¹²ÓÐ
id(varchar2(100)),name(varchar2(100)),parent(varchar2(100))ÕâÈý¸ö×ֶΡ£
½ØÖ¹ÈÕÆÚ½ñÍí22:00¡£
ÏȰÝл£¬ÔÙ°Ýл£¡£¡£¡
È»ºóÀïÍ·ÔÙËæ±ã¸ø¼¸¸öÊý¾ÝÐаɣ¡
лл£¡·¢ÎÒÓÊÏäxonorya@gmail.com
»ù±¾µÄ²Ù×÷...
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977
Êǵģ¬¿ÉÊÇÎҵĵçÄÔ×î
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.
ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£
°ï¶¥......
------------------------------------------------------------------------------
Blog£º http://b ......
ÔÚOracleÖÐÔõôɾ³ýÖØ¸´µÄÐУ¬µ«Òª±£ÁôÒ»Ìõ¼Ç¼¡£
delete table where rowid not in (select max(rowid) from table group by col1,col2,...,coln);
¶Ô£¬ÓÃrowid À´¹ýÂË.
delete tb a
where a.rowid > ......