ORACLE dblink С¼Ç
½¨DBLINK:
ʹÓÃpl/sql developer½¨£ºÕÒµ½Database Links,ÓÒ¼üн¨
Ãû³Æ£ºdblinkÃû Á¬½Óµ½Óû§Ãû£ºÄ¿±êÊý¾Ý¿âµÇ¼Ãû ÃÜÂ룺Ŀ±êÊý¾Ý¿âÃÜÂë
Êý¾Ý¿â£ºÄ¿±êÊý¾Ý¿â·þÎñÃû
²éѯ±í£º
select * from Óû§Ãû.±í @DBLINKÃû³Æ where Ìõ¼þ;
²éѯº¯Êý£º
select Óû§Ãû.º¯ÊýÃû@DBLINKÃû³Æ(²ÎÊý) from dual;
ÔÚ±¾µØº¯ÊýÖе÷ÓÃdblinkº¯Êý£º
Result:=Óû§Ãû.º¯ÊýÃû@DBLINKÃû³Æ(²ÎÊý);
¸´ÖÆdblinkÖеıí½á¹¹ÓëÊý¾Ý:
CREATE TABLE ±íÃû AS SELECT * from Óû§Ãû.±íÃû@DBLINKÃû³Æ where Ìõ¼þ
Ë÷ÒýÕâЩ¿ÉÒÔʹÓÃÊÖ¹¤½¨:ÔÚpl/sql developerµÄSQL´°¿ÚÖÐÑ¡ÖбíÃûÔٲ鿴±í½á¹¹
±¸×¢:
Èç¹û»ú×ÓÉÏͬʱ°²×°ORACLEµÄÊý¾Ý¿âÓë¿Í»§¶Ë,ÒªÓÃÊý¾Ý¿â½¨ÐèÁ¬½ÓdblinkµÄÊý¾Ý¿âµÄ·þÎñ
ÔÚ¹ý³ÌÖд´½¨±íʱҪÏȸøȨÏÞexecUTE immediate 'Grant Create any table to Óû§Ãû';
´ÓdblinkµÄ´ÓÕűíÖÐÈ¡ÊýÖ»ÐèÔÚÿ¸ö±íÃûºó¼Ó@dblinkÃû³Æ
Ïà¹ØÎĵµ£º
How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Orac ......
¹ØÓÚ°²×°£º
°²×°Oracle10gʱ£¬ËùÊäÈëµÄÈ«¾ÖµÄSIDÃû³ÆΪtest(¼´Êý¾Ý¿âÃû£¬²»ÄÜ×÷ΪÓû§ÃûÀ´µÇ¼)£¬ÃÜÂëΪtest(¸ÃÃÜÂë¶ÔÓ¦µÄÓû§Îªsystem£¬sysµÈ)¡£
×°Íêºó£¬Èô´ÓÍøÒ³ÉϵǼoracle£¬ÔòÊäÈëurl£ºhttp://localhost:1158/em
ÈôÎÞ·¨ÏÔ ......
¶¨Ò壺escape¹Ø¼ü×Ö¾³£ÓÃÓÚʹijЩÌØÊâ×Ö·û£¬ÈçͨÅä·û£º'%','_'תÒåΪËüÃÇÔ
À´µÄ×Ö·ûµÄÒâÒ壬±»¶¨ÒåµÄתÒå×Ö·ûͨ³£Ê¹ÓÃ'\',µ«ÊÇÒ²¿ÉÒÔʹÓÃÆäËûµÄ·ûºÅ¡£
ʵÀý£º
SQL> select * from t11 where name like '%_%';
NAME
----------
aa_a
aaa
SQL> select * from t11 where name like '%\_%' escape '\';
NAME
......
Author: rainnyzhong
Date:2010-1-15
1£® Ö¢×´ÃèÊö£º
FALB12´ÓEXCEL IMPORT DATAµ½DB£¬Ô¤¼ÆÊÂÎñ»áÔËÐÐ1¸ö¶àСʱ£¬ÔÚ¿ªÊ¼²Ù×÷ºó40·ÖÖÓ×óÓÒ£¬ORACLE¹ÒËÀ£¬ÈκÎÓû§¶¼²»¿ÉÒÔÔٵǽÁË¡£
2£® ·ÖÎö
£¨1£© ÏÂÃæÊǹÒËÀʱOSµÄ×ÊÔ´×´¿ö£º
09:37:54 up 73 ......
Óû§ºÅÂë µÇ½ʱ¼ä
1300000000 2010-01-01
1300000001 2010-01-01
1300000002 2010-01-02
1300000001 2010-01-02
1300000003 2010-01-03
1300000002 2010-01-03
1300000004 2010-01-04
1300000003 2010-01-04
1300000004 2010-01-02
1300000006 2011-01-04
1300000001 2011-01-04
ÌÞ³ýÖظ´µ ......