Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

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

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

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

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