³õѧoracle¡£Ó¦¸ÃѡʲôÊ飿 - Oracle / »ù´¡ºÍ¹ÜÀí
¸÷λÀÏ´óÃÇÍÆ¼ö±¾Êé°É¡«
×îºÃ²»ÒªÔÛ¹ú¼ÒÈËдµÄ£®ÎÒÒ»Ö±¸Ð¾õÔÛÃǹúµÄר¼ÒÃÇдÊéÍùÄÑÁËдËùÓÐÈ˶Á²»¶®ËûÃDzŸßÐË£®£®
Óб¾ÊéºÃÏñÊÇ¡®¾«Í¨9i/10g ±à³Ì¡¯Í¦»ù´¡µÄ¡£
ÏëÁ˽âÌåϵ½á¹¹¿ÉÒÔÑ¡¡¶Oracle9i&10g±à³ÌÒÕÊõ££ÉîÈëÊý¾Ý¿âÌåϵ½á¹¹¡· ÈËÃñÓʵç³ö°æÉç
ÈôÊÇÏëѧSQL»òÊÇPL/SQLÄÇ¿ÉÑ¡µÄÊéÓкܶ࣬LZ×Ô¼º¶àÕÒÕÒ°É¡£
Oracle one by one
¿°³Æ¾µä
ÄãÊÇѧÉú¾ÍȥͼÊé¹Ý°É
¸øÄãÒ»¸öÍâÎÄÊé¼®Çåµ¥£º
2005-08-10 00:15 1,507,311 43061-ora92errmsg.chm
2009-02-13 22:18 <DIR> 9i
2005-06-03 00:42 1,305,519 Advanced Oracle PL_SQL - Programming With Packages - O'Reilly.chm
2009-02-13 22:18 <DIR> Apress expert one-on-one oracle sourcecode
2005-04-24 13:49 421,499 Apress expert one-on-one oracle sourcecode.zip
2005-12-27 16:52 4,985,126 Apress.Expert.Oracle.Database.Architecture.9i.and.10g.Programming.Techniques.and.Solutions.Sep.2005.pdf
2008-09-02 08:50 9,318,509 Apress.Troubleshooting.Oracle.Performance.pdf
2005-01-26 18:29 8,652,845 Apress_Expert one on one Oracle.pdf
2005-08-08 01:40 32,484,619 Apress_Expert one-on-one Oracle_cn.pdf
2009-02-13 22:18 <DIR> Effective Oracle by Design
2006-07-23 11:55 78,019 Effective Oracle by Design.zip
2005-06-03 12:55 10,246,532 Expert Oracle 9I Database Administration - Apress(2003).chm
2006-07-24 16:20
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......