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Óû§Ãû) ÕâÑù¿ÉÒÔ£¬ÎÒ¶¼ÊÇÕâÑùÓÃµÄ ×ÖĸҪȫ´óдµÄ¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
Á½¸öÎļþ1.PC£¬1.inc 1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
´æ´¢¹ý³Ì£º create or replace procedure insert_emp (empid in number, empname in varchar2, empsal in number) as begin insert into emp(empno,ename ......