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

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')


Ïà¹ØÎĵµ£º

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

oracle internal number Êý¾ÝÀàÐÍ´æ´¢

ת×Ô£ºhttp://ilonng.blog.sohu.com/130335741.html
   oracleµÄnumberÀàÐÍÊÇÒ»ÖÖÈí¼þÊý¾ÝÀàÐÍ£¬ÔÚoracleÈí¼þ±¾ÉíÖÐʵÏÖ£¬ÎÒÃDz»ÄÜʹÓùÌÓÐÓ²¼þ²Ù×÷½«Á½¸önumberÀàÐÍÏà¼Ó£¬ÕâÒªÔÚÈí¼þÖÐÄ£Ä⣬number ÀàÐ͵ÄÄÚ²¿±àÂëÊÇ2¡£oracle´æ´¢Ò»¸öÊýµÄʱ£¬»á´æ´¢¾¡¿ÉÄÜÉÙµÄÄÚÈÝÀ´±íʾÕâ¸öÊý£¬Îª´ËËü»á´æ´¢ÓÐЧÊý×Ö¡¢ÓÃÓÚÖ¸¶ ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns th ......

ÈçºÎÅäÖúÍÖØ½¨Oracle 10GµÄem·þÎñ dbcontrol

Oracle10GµÄEM²ÉÓÃÁËweb·½Ê½£¬²¢ÇÒ·Ö³ÉÁË2¸ö²úÆ·£¬database controlºÍgrid control¡£ÕâÀïÖ÷Òª½éÉÜÈçºÎ´´½¨µ¥Êý¾ÝµÄdbcontrol¡£Grid controlÐèÒªÏÂÔØµ¥¶ÀµÄ¹âÅ̰²×°¡£
ÔÚÓÃDBCA½¨¿âµÄʱºò£¬¿ÉÒÔÑ¡ÔñÊÇ·ñÆôÓÃdbcontrol£¬ÆôÓõϰÐèÒªÔÚ
Êý¾Ý¿â
Öн¨Á¢Ò»¸ösysmanµÄschema£¬ÓÃÓÚ±£´æEMµÄһЩÊý¾Ý£¬Õâ¸ö¾ÍÊÇEMµÄ×ÊÁÏ¿â(reposi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ