oracleÓësqlserver²åÈëÊý¾Ý¶¯Ì¬×Ö¶ÎÖµ
¼Ç¼һÏÂÒÔ±¸Ï´οìËÙÕÒµ½¡£¡£¡£
Íùtb_wf_privgrant±íÖвåÈëÒ»Ìõ¼Ç¼£¬workflow_id×Ö¶ÎÖµ´Ótb_wf_workflow ±íÖлñÈ¡workflow_name='֪ʶÉóºË'µÄËùÓмǼÖÐworkflow_id×î´óÖµ¡£
--oracle
declare a NUMBER(10);
begin
select max(workflow_id) into a from tb_wf_workflow where workflow_name='֪ʶÉóºË';
insert into tb_wf_privgrant(grant_Id,workflow_id,member_id,member_type,knowledge_code) values (HIBERNATE_SEQUENCE.NEXTVAL, a,'r001','R','6001');
end;
--sqlserver
--·½·¨Ò»
insert into tb_wf_privgrant(workflow_id,member_id,member_type,knowledge_code)
select max(workflow_id),'r001','R','6001' from tb_wf_workflow where workflow_name='֪ʶÉóºË'
--·½·¨¶þ
declare @a numeric(10,0)
select @a = max(workflow_id) from tb_wf_workflow where workflow_name='֪ʶÉóºË'
insert into tb_wf_privgrant(workflow_id,member_id,member_type,knowledge_code)
values (@a,'r001','R','6001')
Ïà¹ØÎĵµ£º
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
Oracle10GµÄEM²ÉÓÃÁËweb·½Ê½£¬²¢ÇÒ·Ö³ÉÁË2¸ö²úÆ·£¬database controlºÍgrid control¡£ÕâÀïÖ÷Òª½éÉÜÈçºÎ´´½¨µ¥Êý¾ÝµÄdbcontrol¡£Grid controlÐèÒªÏÂÔØµ¥¶ÀµÄ¹âÅ̰²×°¡£
ÔÚÓÃDBCA½¨¿âµÄʱºò£¬¿ÉÒÔÑ¡ÔñÊÇ·ñÆôÓÃdbcontrol£¬ÆôÓõϰÐèÒªÔÚ
Êý¾Ý¿â
Öн¨Á¢Ò»¸ösysmanµÄschema£¬ÓÃÓÚ±£´æEMµÄһЩÊý¾Ý£¬Õâ¸ö¾ÍÊÇEMµÄ×ÊÁÏ¿â(reposi ......
ÓÐЩ³£¼ûµÄÎÊÌâÔÚÂÛ̳Öв»¶Ï³öÏÖ£¬²»·ÁÕûÀíһϡ£
ÒÔÏÂÓï¾äÊÇÔÚSQLServer2005ÉÏʵÏֵģ¬Ò»Ð©Óï¾äÎÞ·¨ÔÚSS2000ÉÏÖ´ÐС£
ÓÐÓÃÖ¸ÊýÊÇÎÒ¸ù¾ÝÕâ¸öÎÊÌâµÄ³£¼û³Ì¶È´òµÄ·Ö£¬½ö¹©²Î¿¼¡£Êµ¼ÊÉÏ£¬µ±ÄãÓöµ½ÁËÕâ¸öÎÊÌ⣬Õâ¸öÎÊÌâÄÄÅÂÔÙÉÙ¼û£¬½â¾ö·½°¸Ò²ÊǷdz£ÓÐÓõġ£
1. Éú³ÉÈô¸ÉÐмǼ
ÓÐÓÃÖ¸Êý£º¡ï¡ï¡ï¡ï¡ï
³£¼ûµÄÎÊÌâÀàÐÍ£º¸ù¾Ý ......