OracleÊý¾Ý¿â¶Ë¿ÚÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø
¸÷λÅóÓÑ£º OracleÊý¾Ý¿âĬÈϵÄÁ´½Ó¶Ë¿ÚÊÇ1521£¬Èç¹ûÒªÐ޸쬏ÃÔõôÐ޸ģ¿ ±»Ð޸ĺó£¬ÈçºÎ²é¿´Êý¾Ý¿âµ±Ç°Á´½ÓµÄÊÇÄĸö¶Ë¿ÚÄØ£¿
ÐÞ¸ÄÕìÌýÎļþlistener.ora,ÕÒµ½ÎļþÄÚÈÝPORT = 1521,°Ñ1521Ð޸ijÉÄãÐèÒªµÄ¶Ë¿Ú,ÖØÐÂÆô¶¯ÕìÌý·þÎñ. лл£¬ÎÒÊÇÐÂÊÖ£¬ÕìÌýÎļþlistener.oraµÄλÖÃÔÚÄÄ£¿ÈçºÎÆô¶¯ÕìÌý·þÎñ£¿ °²×°ºó£¬ÅäÖù¤¾ß NET MANAGEÐÞ¸ÄÒýÓà лл£¬ÎÒÊÇÐÂÊÖ£¬ÕìÌýÎļþlistener.oraµÄλÖÃÔÚÄÄ£¿ÈçºÎÆô¶¯ÕìÌý·þÎñ£¿ 1.ÕìÌýÎļþlistener.oraµÄλÖÃÔÚÄÄ: $ORACLE_HOME/network/admin Ŀ¼Ï£¡ 2.ÈçºÎÆô¶¯ÕìÌý·þÎñ£º cmd--> lsnrctl start
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ 1,2,3,4 ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û 1 2 3 4 ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö??? ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó SQL code: wi ......