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

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


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

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

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

OracleÐÐתÁÐ - Oracle / ¸ß¼¶¼¼Êõ

select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó

SQL code:
wi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ