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

server2005Á´½Ó·þÎñÆ÷·ÃÎÊoracle,Êý¾Ý²éѯ

EXECUTE SP_ADDLINKEDSERVER 
@SERVER='CDMA',
@SRVPRODUCT='Oracle',
@Provider='MSDAORA',
@DataSrc='CDMA'

--Óû§Ó³Éä
EXEC SP_ADDLINKEDSRVLOGIN 'CDMA','FALSE','sa','cdmauser','cdmaoptr'
--ÔÊÐíRPCµ÷Óã¬ÒÔÖ´Ðд洢¹ý³Ì£» 
exec  sp_serveroption  N'CDMA',  N'rpc',  N'true'

Óï¾äA
SELECT * from CDMA..CDMAUSER.BTSSTATUS_OSS701
ÄÜÕý³£Ô¶ÐÐ


Óï¾äB
SELECT * from CDMA..CDMAUSER.GISDATAUSER.T20091226ÈýÑÇÊÐÌìRP
³ö´í
ÏûÏ¢ 117£¬¼¶±ð 15£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
¶ÔÏó Ãû³Æ 'CDMA..CDMAUSER.GISDATAUSER.T20091226ÈýÑÇÊÐÌìRP¡¯°üº¬µÄǰ׺³¬³öÁË×î´óÏÞÖµ¡£×î¶àÖ»ÄÜÓÐ 3 ¸ö¡£

ÕâÊÇΪʲô£¬¸ÃÔõÑù½â¾ö£¿

ÔÚORACLEÖУ¬SELECT * from GISDATAUSER.T20091226ÊÇÕý³£µÄ

ÔÚORACLEÖУ¬SELECT * from GISDATAUSER.T20091226ÈýÑÇÊÐÌìRP ÊÇÕý³£µÄ


ÔõôûÓиßÊÖÖ¸½Ìѽ£¡£¡£¡

Ó¦¸ÃÕâÑùд£º
SELECT * from (Á´½Ó·þÎñÆ÷Ãû)..(OracleÓû§Ãû).±íÃû;
ÒÔÉϾù´óд¡£

select * from ±íÃû@(Á´½Ó·þÎñÆ÷Ãû)..(OracleÓû§Ãû)
ÕâÑù¿ÉÒÔ£¬ÎÒ¶¼ÊÇÕâÑùÓõÄ

ÒýÓÃ
select * from ±íÃû@(Á´½Ó·þÎñÆ÷Ãû)..(OracleÓû§Ãû)
  ÕâÑù¿ÉÒÔ£¬ÎÒ¶¼ÊÇÕâÑùÓõÄ

×ÖĸҪȫ´óдµÄ¡£


Ïà¹ØÎÊ´ð£º

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

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

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

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

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

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

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

javaµ÷´æ´¢¹ý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

´æ´¢¹ý³Ì£º
create or replace procedure insert_emp
 (empid in number,
 empname in varchar2,
 empsal in number)
 as
 begin 
  insert into emp(empno,ename ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ