Oracle DB Link
Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
1¡¢ ÅäÖÃTNS £¬ $ORACLE_HOME/NETWORK/ADMIN/tnsname.ora
10gstandby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-3068)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 10gstandby)
)
)
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
create public database link DB_LINK_NAME connect to TargetDatabaseUserName identified by TargetDatabasePassword using 'TargetDatabaseSIDName';
×¢£ºTargetDatabaseSIDNameΪ¸ÃOracleÊý¾Ý¿âËùÔÚµÄÖ÷»úÉϵÄtnsnames.oraÎļþÀï±ß¶¨ÒåµÄÊý¾Ý¿âÁ¬½Ó´®¡£
SQL>create public database link dvd connect to system identified by system using 'orcl10g';
Ôò´´½¨ÁËÒ»¸öÒÔsystemÓû§ºÍorcl10gÊý¾Ý¿âµÄÁ´½Ódvd£¬ÎÒÃDzéѯdvdÊý¾Ý:
SQL>select * from all_users@dvd;
ÕâÑù¾Í¿ÉÒ԰ѱ¾µØºÍÔ¶³ÌµÄÊý¾Ý×ö³ÉÒ»¸öÕûÌåÀ´´¦Àí¡£
3¡¢½¨Á¢Í¬Òå´Ê£¬ÎªÁËʹÓйطֲ¼Ê½²Ù×÷¸ü͸Ã÷£¬ORACLEÊý¾Ý¿âÀïÓÐͬÒå´ÊµÄ¶ÔÏósynonym
SQL>create synonym synTest for all_users@dvd;
ÓÚÊǾͿÉÒÔÓÃsynTestÀ´Ìæ´ú´ø@·ûºÅµÄ·Ö²¼Ê½Á´½Ó²Ù×÷all_users@dvd;
4¡¢²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£º
SQL>select owner,object_name from dba_objects where object_type='DATABASE LINK';
5¡¢²é¿´Êý¾Ý¿âÁ¬½Ó
sql> select owner, db_link from dba_db_links;
ower db_link
public DVD.REGRESS.RDBMS.DEV.US.ORACLE.COM
6¡¢É¾³ýÊý¾Ý¿âÁ¬½Ó
ÏÈ´ÓµÚ5²½Öв鿴Êý¾Ý¿âÁ¬½Ó£¬È¡µÃÆädb_linkµÄÃû³Æ
sql>drop public database link DVD.REGRESS.RDBMS.DEV.US.ORACLE.COM
Êý¾Ý¿âÁ¬½ÓËȶªÆú
Ïà¹ØÎĵµ£º
²é¿´Oracle ±í½á¹¹µÄ´´½¨ºÍ×îºóÐÞ¸Äʱ¼ä
SELECT a.owner, a.table_name, created, last_ddl_time
from dba_tables a, SYS.dba_objects b
WHERE a.tablespace_name = 'USERS'
AND a.owner = b.owner
AND a.table_name = b.object_name
AND object_type = 'TABL ......
±¸×¢£º¾¹ýǰÆÚµÄlinuxϵͳ»·¾³µÄÅäÖôÍê³É£¬ÏÂÃæ¾Í¿ªÊ¼°²×°oracleÊý¾Ý¿â¡£oralceÊý¾Ý´ó¼ÒÈ¥oracle¹Ù·½ÍøÕ¾ÉÏÏÂÔØlinux»·¾³Ïµİ汾¡£ºÜÒź¶½ØÍ¼ÉÏ´«²»ÁË¡£
Èý£®Oracle database°²×°¾ßÌå°²×°²½Öè
<1>´´½¨°²×°oracleĿ¼¼°Ö÷Êôµ÷Õû
[root@mylinux oracle]# mv database/ /u01
[root@mylinux u ......
ÓÃQt¿ª·¢Oracle³ÌÐòʱ£¬³£»áÓöµ½QOCIÇý¶¯ÎÊÌ⣬Ö÷Òª±íÏÖΪ³ÌÐòÔËÐÐʱ³öÏÖÏÂÃæµÄ´íÎó¡£
QOCI driver not loaded
available drivers: QSQLITE QODBC3 QODBC
Õâ˵Ã÷ûÓа²×°QtÖ§³ÖOracleµÄÇý¶¯¡£
.
ÒªÏë±ÜÃâÕâ¸öÎÊÌ⣬µÚÒ»ÖÖ·½·¨ÊÇʹÓÃЧÂʵÍϲ¢ÇÒ·ÑʵÄODBC£»µÚ¶þÖÖ·½·¨¾ÍÊǰ²×°QOCIÇý¶¯¿©~
.
Ҫ˵һϵÄÊÇ£ºQOCIÔÚqt ......
oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......
oracleʵÀýÃû,·þÎñÃûµÈ¸ÅÄîÇø±ðÓëÁªÏµ
Ò»¡¢Êý¾Ý¿âÃûITPUB¸öÈ˿ռäv{7x6lo\
ʲôÊÇÊý¾Ý¿âÃû£¿ITPUB¸öÈ˿ռä*s*R5LVBXZ2w$I
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²Î ......