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

OracleÓû§Ãû - Oracle / »ù´¡ºÍ¹ÜÀí

OracleÖÐÓû§ÃûÊÇʲô£¿
ÃèÊöÇå³þÒ»µã£¡
ORACLEÊý¾Ý¿âÖÐÓкܶàÄÚÖõÄÓû§Ãû£¬sys¾Í²»ËµÁË£¬»¹ÓÐscottÃÜÂëÊÇtiger.³ýÁËsys,ÆäËûÓû§¶¼ÊÇËù¶¨µÄ£¬½â³ýËø¶¨ºó²ÅÄÜʹÓá£ÔÚ±¾»úµÇ½Êý¾Ý¿âʱ£¬sysµÄÃÜÂë¿ÉÒÔËæÒâÊäÈë¡£


sys
system
....




Óû§ÃûÊǵǼÊý¾Ý¿âµÄ±êʶ£¬µ±È»µÇ¼ʱ»¹ÒªÖ¸¶¨ÃÜÂ룬
Óû§ÊÇoracleÖжàÖÖ¶ÔÏó£¨Èç±í¡¢Ë÷ÒýµÈ£©µÄÓµÓÐÕß¡£


sys
system
scott
Õ⼸¸öÊÇĬÈϾÍÓе쬯äËûµÄÒª×Ô¼º½¨


Ïà¹ØÎÊ´ð£º

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......

oracle ´æ´¢¹ý³ÌÖÐÓ¦ÓÃÊÂÎñµÄÎÊÌâ - Oracle / ¿ª·¢

SQL code:

CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ