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

¹ØÓÚoracleÊý¾Ýͬ²½µÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÒµÎñÐèÇóÊÇÖÐÉæ¼°µ½´ÓÊ¡¾ÖÊý¾Ý¿âÖн«Êý¾Ýͬ²½µ½ÊоֵÄÊý¾Ý¿âÖУ¬ÌýÁìµ¼µÄÒâ˼ÊÇÓÃdb_linkÀ´ÊµÏÖ¡£ÏÖÔÚ¶Ôdb_linkÒ»µã¸ÅÄûÓС£Ï£Íû¸÷λ´óϺÌṩµã˼·»òÕß¿ÉÄÜÓöµ½µÄÇé¿ö»òÕß×ÊÁÏ¡£
ллÁË¡£


ѧϰÁË

лл¸÷λ´ó¸çµÄ»Ø¸´£¬ÎÒÏÖÔÚÏÈ¿´2Â¥´ó¸çÌṩµÄ×ÊÁÏɨɨ䣬¾ßÌåʵÏÖʱµÄÓöµ½µÄÎÊÌâÔÙÀ´Çë½Ì¡£

ÒýÓÃ

dblink¼òµ¥µØËµ¾ÍÊÇ´ÓÒ»¸öÊý¾Ý¿âÁ¬½ÓÁíÒ»¸öÊý¾Ý¿âµÄͨµÀ

Äã¿ÉÒÔÔÚÊоֵÄÊý¾Ý¿âÖн¨Á¢Ò»¸ödblinkÈçÏÂ:

create database link link_to_province
connect to <Ê¡¿âÓû§Ãû> identified by <Óû§ÃÜÂë>
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOC¡­¡­

Ö§³Ö


Ïà¹ØÎÊ´ð£º

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

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

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

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

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

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

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

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ºÅ