oracle link
Á©Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
´´½¨¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½Ê½£º
1¡¢ÒѾÅäÖñ¾µØ·þÎñ
create public database
link fwq12 connect to fzept
identified by neu using 'fjept' CREATE DATABASE LINKÊý¾Ý¿âÁ´½ÓÃûCONNECT TO Óû§Ãû IDENTIFIED BY ÃÜÂë USING ‘±¾µØÅäÖõÄÊý¾ÝµÄʵÀýÃû’;
2¡¢Î´ÅäÖñ¾µØ·þÎñ
create database link linkfwq
connect to fzept identified by neu
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.202.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fjept)
)
)';
host£½Êý¾Ý¿âµÄipµØÖ·£¬service_name£½Êý¾Ý¿âµÄssid¡£
ÆäʵÁ½ÖÖ·½·¨ÅäÖÃdblinkÊDz¶àµÄ£¬ÎÒ¸öÈ˸оõ»¹ÊǵڶþÖÖ·½·¨±È½ÏºÃ£¬ÕâÑù²»Êܱ¾µØ·þÎñµÄÓ°Ïì¡£
Êý¾Ý¿âÁ¬½Ó×Ö·û´®¿ÉÒÔÓÃNET8 EASY CONFIG»òÕßÖ±½ÓÐÞ¸ÄTNSNAMES.ORAÀﶨÒå.
Êý¾Ý¿â²ÎÊýglobal_name=trueʱҪÇóÊý¾Ý¿âÁ´½ÓÃû³Æ¸úÔ¶¶ËÊý¾Ý¿âÃû³ÆÒ»Ñù
Êý¾Ý¿âÈ«¾ÖÃû³Æ¿ÉÒÔÓÃÒÔÏÂÃüÁî²é³ö
SELECT * from GLOBAL_NAME;
²éѯԶ¶ËÊý¾Ý¿âÀïµÄ±í
SELECT …… from ±íÃû@Êý¾Ý¿âÁ´½ÓÃû;
²éѯ¡¢É¾³ýºÍ²åÈëÊý¾ÝºÍ²Ù×÷±¾µØµÄÊý¾Ý¿âÊÇÒ»ÑùµÄ£¬Ö»²»¹ý±íÃûÐèҪд³É“±íÃû@dblink·þÎñÆ÷”¶øÒÑ¡£
¸½´ø˵ÏÂͬÒå´Ê´´½¨:
&nb
Ïà¹ØÎĵµ£º
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
Oracle Connect ByÓ÷¨
oracleÖеÄselectÓï¾ä¿ÉÒÔÓÃSTART WITH...CONNECT BY PRIOR×Ó¾äʵÏֵݹé²éѯ£¬connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from <TableName>
where <Conditional-1>
start with <Conditional-2>
connect by <Conditional-3>
;
<Conditi ......
OracleµÄÔÚÏßÖض¨Òå±í¹¦ÄÜ
http://blog.itpub.net/post/468/12855
http://blog.itpub.net/post/468/12962
ÔÚÒ»¸ö¸ß¿ÉÓÃϵͳÖУ¬Èç¹ûÐèÒª¸Ä±äÒ»¸ö±íµÄ¶¨ÒåÊÇÒ»¼þ±È½Ï¼¬ÊÖµÄÎÊÌ⣬ÓÈÆäÊǶÔÓÚ7×24ϵͳ¡£OracleÌṩµÄ»ù±¾Óï·¨»ù±¾¿ÉÒÔÂú×ãÒ»°ãÐÔÐ޸ģ¬µ«ÊǶÔÓÚ°ÑÆÕͨ¶Ñ±í¸ÄΪ·ÖÇø±í£¬°ÑË÷Òý×éÖ¯±íÐÞ¸ÄΪ¶Ñ±íµÈ²Ù×÷¾ÍÎÞ ......