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

OracleÏîÄ¿¿ª·¢Ê±Óû§È¨ÏÞ·ÖÅä - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸öÒÉÎÊ£º
×î½üÒªÓÃoracle×öÒ»¸öϵͳ£»
·¢ÏÖoracle¶ÔÓÚ²»Í¬µÄschema/user¿ÉÒÔ½¨²»Í¬µÄ±í£¬¶øÇÒ»¥ÏàÊDz»¿É¼ûµÄ£»
¸÷λ¸ßÈË£¬ÔÚ¾ßÌåµÄÏîÄ¿ÖÐÊÇÔõô¶Ô²»Í¬µÄÓû§½øÐÐȨÏÞ·ÖÅäµÄ£¿
²¢±£Ö¤Ã¿¸öÓû§µÄ²Ù×÷¶¼ÊÇÕë¶ÔÏàͬµÄ±í£¿
лл

ÆäʵÎÒµÄÎÊÌâÓ¦¸ÃÊÇÕâÑùµÄ£º´Ó´úÂëµÄ½Ç¶ÈÉÏ¿´£¬¿Ï¶¨ÊÇÒ»Ö£¬ÒòΪ´ÓSVNÉÏǨ³öµÄ´úÂë·ÃÎÊÊý¾Ý¿âµÄschema/userÊÇÒ»ÑùµÄ¡£µ«ÊÇΪÁËÊý¾Ý¿âµÄ°²È«ÐÔ¿¼ÂÇ£¬ÔÚ¿ª·¢µÄ¹ý³Ì»á¶Ô²»Í¬µÄÓû§¸³Ó벻ͬµÄȨÏÞ£¬±ÈÈ翪·¢ÈËÔ±£¬ËûÃÇÓÃ×Ô¼ºµÄÕʺŵǼpl/sql£¬µ«ËûÃÇÐèÒª²éѯÊý¾Ý¿âµÄÆäËü±í»òÕßÐ޸Ĵ´½¨×Ô¼ºµÄ±í£¬µ«ÆäʵÕâÑùµÄÐ޸Ĵ´½¨ÊÇÕë¶Ô³ÌÐò´úÂëÖÐÓõÄschema/user¶øÑԵġ£ÕâʱӦ¸ÃÔõô¸³È¨ÏÞ²ÅÄܱ£Ö¤Íê³ÉÕâÑùµÄ¹¦ÄÜÄØ£¿

ÎÒºÜÏë¿´Ò»ÏÂÆäËüÅóÓÑÊÇÈçºÎÔÚÏîÄ¿ÖÐʵ¼ÊÔËÓã»
Ï£ÍûÓо­ÑéµÄÅóÓÑÖ¸µ¼Ò»Ï£»

ÈÃÏëʹÓøñíµÄÓû§¶¼±»ÊÚÓè²Ù×÷¸Ã±íÒÔ¼°¸Ã±íËùÔÚ±í¿Õ¼äµÄ²Ù×÷ȨÏÞ£¬ÕâÑùÓ¦¸Ã¿ÉÒÔÁË

ÒýÓÃ
ÎÒÓÐÒ»¸öÒÉÎÊ£º
×î½üÒªÓÃoracle×öÒ»¸öϵͳ£»
·¢ÏÖoracle¶ÔÓÚ²»Í¬µÄschema/user¿ÉÒÔ½¨²»Í¬µÄ±í£¬¶øÇÒ»¥ÏàÊDz»¿É¼ûµÄ£»
¸÷λ¸ßÈË£¬ÔÚ¾ßÌåµÄÏîÄ¿ÖÐÊÇÔõô¶Ô²»Í¬µÄÓû§½øÐÐȨÏÞ·ÖÅäµÄ£¿
²¢±£Ö¤Ã¿¸öÓû§µÄ²Ù×÷¶¼ÊÇÕë¶ÔÏàͬµÄ±í£¿
лл

ΪʲôҪ´´½¨²»Í¬µÄÊý¾Ý¿âÓû§£¿´ó¼ÒÍêÈ«¿ÉÒÔʹÓÃͬһ¸öÓû§µÄ¡£
Èç¹ûÕæÒªÊ¹Óò»Í¬µÄÓû§£¬Í¬Ê±»¹Òª·ÃÎÊÏàͬµÄ±í£¬ÄǾʹ´½¨±ðÃûºÃÁË¡£


¿ª·¢ÊÇÓÿª·¢¿âµÄºÃ°É£¬ÄѵÀ¿ª·¢µÄʱºòÁ¬Éú²ú¿â£¬Äã²»ÊǸãЦÂï
ʣϵÄÈç¹ûÊǽâ¾ö¹ÊÕÏÎÊÌ⣬±ÈÈçÐèÒª¿ª·¢µÄÅäºÏ£¬ÄǾÍÊǶÔÉú²ú¿âÁÙʱ¸³È¨µÄÎÊÌ⣬±ÈÈçqueryÓû§µÈµÈ¡£


»Ø¸´ËÄÂ¥£º
  ȷʵ¿ÉÒÔ°ÑÒ»¸ö±íµÄȨÏÞ¸³¸øÐèҪʹÓõÄÓû§£¬µ«ÊÇÿ¸ö


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......

Oracle ¸ßÊÖ½ø - Java / Java EE

SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21
SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ