OracleµÄͬÒå´Ê£¨synonyms£©×ܽá
oracleµÄͬÒå´Ê×ܽ᣺
¡¡¡¡´Ó×ÖÃæÉÏÀí½â¾ÍÊDZðÃûµÄÒâ˼£¬ºÍÊÔͼµÄ¹¦ÄÜÀàËÆ¡£¾ÍÊÇÒ»ÖÖÓ³Éä¹ØÏµ¡£
¡¡¡¡1.´´½¨Í¬Òå´ÊÓï¾ä£º
¡¡¡¡create public synonym table_name for user.table_name;
¡¡¡¡ÆäÖеÚÒ»¸öuser_tableºÍµÚ¶þ¸öuser_table¿ÉÒÔ²»Ò»Ñù¡£
¡¡¡¡´ËÍâÈç¹ûÒª´´½¨Ò»¸öÔ¶³ÌµÄÊý¾Ý¿âÉϵÄijÕűíµÄͬÒå´Ê£¬ÐèÒªÏÈ´´½¨Ò»¸öDatabase Link(Êý¾Ý¿âÁ¬½Ó)À´À©Õ¹·ÃÎÊ£¬È»ºóÔÚʹÓÃÈçÏÂÓï¾ä´´½¨Êý¾Ý¿âͬÒå´Ê£ºcreate synonym table_name for table_name@DB_Link;
¡¡¡¡µ±È»£¬Äã¿ÉÄÜÐèÒªÔÚuserÓû§Öиøµ±Ç°Óû§(user2)ÊÚȨ£º grant select/delete/update on user2
¡¡¡¡2.ɾ³ýͬÒå´Ê£º
¡¡¡¡drop public synonym table_name;
¡¡¡¡3.²é¿´ËùÓÐͬÒå´Ê£º
¡¡¡¡select * from dba_synonyms
¡¡¡¡Í¬Òå´ÊÓµÓÐÈçϺô¦£º½ÚÊ¡´óÁ¿µÄÊý¾Ý¿â¿Õ¼ä£¬¶Ô²»Í¬Óû§µÄ²Ù×÷ͬһÕűíûÓжàÉÙ²î±ð;À©Õ¹µÄÊý¾Ý¿âµÄʹÓ÷¶Î§£¬Äܹ»ÔÚ²»Í¬µÄÊý¾Ý¿âÓû§Ö®¼äʵÏÖÎÞ·ì½»»¥;ͬÒå´Ê¿ÉÒÔ´´½¨ÔÚ²»Í¬Ò»¸öÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬Í¨¹ýÍøÂçʵÏÖÁ¬½Ó¡£
Ïà¹ØÎĵµ£º
ĿǰÖ÷Á÷Êý¾Ý¿â£º
΢Èí£ºsql serverºÍaccess
ÈðµäMySql£ºAB¹«Ë¾mysql
IBM¹«Ë¾£ºDB2¡¢
ÃÀ¹úSybase¹«Ë¾£ºSybase
IBM¹«Ë¾ ......
δʵÑé
ORACLEÊý¾Ý¿â×Ô´øµÄDBMS_JOB¹¦ÄÜ¿ÉÒÔʵÏÖ¶¨Ê±Ö´ÐÐPL/SQLµÄ´æ´¢¹ý³Ì£¬µ«ÊÇÈç¹ûSQLÓï¾äºÜ¸´ÔÓ£¬
SQLÓï¾äºÜ¶à£¬ÒÔ¼°¾³£Òª¸Ä±äSQLÓï¾äµÄд·¨£¬ÓÃдPL/SQL´æ´¢¹ý³ÌµÄ·½·¨ÔÙ¶¨Ê±Ö´Ðлá±È½Ï·±Ëö¡£ºÎ
¿ö»¹ÓÐһЩUNIXϵͳ¹ÜÀíÔ±²»»áдPL/SQL´æ´¢¹ý³Ì£¬ËùÒÔÎÒ½éÉ ......
ÈÔȻʹÓÃSCOTTÓû§À´²Ù×÷£º
1¡¢ ÏÔʾ¹¤×ʱȲ¿ÃÅ30µÄËùÓÐÔ±¹¤µÄ¹¤×ʶ¼¸ßµÄÔ±¹¤µÄÐÅÏ¢£º
Select * from emp where sal>all(select sal from emp where deptno=30);
2¡¢ ÏÔʾ¹¤×ʱȲ¿ÃÅ30µÄÈÎÒâÒ»¸öÔ±¹¤µÄ¹¤×ʸ߾ͿÉÒ ......