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

°ïÎÒÓÃ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¡£
ÏȰÝл£¬ÔÙ°Ýл£¡£¡£¡
ÒýÓÃ
ÀïÍ·ÓÐÁ½ÕÅ±í£º
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¡­¡­

È»ºóÀïÍ·ÔÙËæ±ã¸ø¼¸¸öÊý¾ÝÐаɣ¡
лл£¡·¢ÎÒÓÊÏä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

ÒýÓÃ
»ù±¾µÄ²Ù×÷...




------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp¡­¡­

Êǵģ¬¿ÉÊÇÎҵĵçÄÔ×î


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

oracle - Oracle / »ù´¡ºÍ¹ÜÀí

oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.

ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£


°ï¶¥......
------------------------------------------------------------------------------ 
Blog£º http://b ......

oracleÊý¾Ý¿â - Oracle / ¸ß¼¶¼¼Êõ

ÔÚOracleÖÐÔõôɾ³ýÖØ¸´µÄÐУ¬µ«Òª±£ÁôÒ»Ìõ¼Ç¼¡£

delete table where rowid not in (select max(rowid) from table group by col1,col2,...,coln);

¶Ô£¬ÓÃrowid À´¹ýÂË.

delete tb a
where a.rowid > ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ