oracleͬÒå´Ê
----------------------------------------------------------------------------
Ïà¹Ø֪ʶ£ºOracle SYNONYM£¨Í¬Òå´Ê£©
----------------------------------------------------------------------------
ÊÇÒ»ÖÖÓ³Éä¹Øϵ£¬¿ÉÒÔÀí½âΪ±íµÄÒ»Ö̶ֹ¨±ðÃû
ͬÒå´ÊµÄºÃ´¦£º½¨Á¢Ò»¸öͬÒå´Ê¿ÉÒÔÅųýÒ»¸ö¶ÔÏóÃû×ÖµÄÏÞÖÆ
Èç¹ûÄãµÄÊý¾Ý¿âÓжà¸öÓû§£¬USER_AÒª·ÃÎÊUSER_BµÄTABLE1,Ö»ÄÜʹÓÃUSER_B.TABLE1
½¨Ò»¸öͬÒå´ÊabcÖ¸ÏòUSER_B.TABLE1,ÄÇÄã¾Í¿ÉÒÔselect * from abcÁË,¶øÇÒpublicµÄͬÒå´Ê»áÖ±½Ó³öÏÖÔÚËùÓÐÓû§µÄÃæÇ°,ÓÐʱºò¿ÉÒÔ·½±ã¿ª·¢
´´½¨Í¬Òå´Ê£ºcreate public synonym synonym_name for user.table_name
ɾ³ýͬÒå´Ê£ºdrop public synonym synonym_name
Ïà¹ØÎĵµ£º
´´½¨oracle job
oracle job¼ò½é
Ö÷ÒªµÄʹÓÃÇé¾°
¶¨Ê±ÔÚºǫִ́ÐÐÏà¹Ø²Ù×÷:ÈçÿÌìÍíÉÏ0µã½«Ò»ÕűíµÄÊý¾Ý±£´æµ½ÁíÒ»ÕűíÖÐ,2£º¶¨Ê±±¸·ÝÊý¾Ý¿âµÈ
Ê컯˵ÍòÊ¿ªÍ·ÄÑ£¬ÕâÀïÎÒÖ»¼òµ¥¼ÇÊöÒ»¸ö´´½¨Ò»¸ö¼òµ¥µÄjob
²½ÖèÈçÏ£º
1¡¢´´½¨Ò»Õűíg_test
create table G_TEST
(
ID NUMBER(1 ......
ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´Òâ˼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......
Ëø
²éѯÆäËûÓû§µÄ±í <Óû§Ãû.±íÃû>
Ëø¶¨Ä£Ê½£º
Ðм¶Ëø
Ðб»ÅÅËûÐÔËø¶¨
ÔÚijÐеÄËø±»ÊÍ·Å֮ǰ£¬ÆäËûÓû§²»ÄÜÐ޸ĴËÐÐ
ʹÓÃcommit rollbackÃüÁîÊÍ·ÅËø
»ñÈ¡Ðм¶Ëø
ʹÓÃinsert¡¢updateÓï¾ä£¬×Ô¶¯ÉÏÐм¶Ëø
ʹÓÃselect...for update [of ÁÐÃû] Óï¾ä×Ô¶¯»ñÈ¡Ðм¶Ëø
ÔÚ±íµÄÒ»Ðлò¶àÐзÅÖÃÅÅËûËø£¬ÓÃÓÚ·ÀÖÎÆäË ......
Îҵݲװ¹ý³Ì
1¡¢±à¼ /etc/apt/sources.list £º
sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
sudo gedit /etc/apt/sources.list
¼ÓÈëÏÂÃæÕâ¸öÔ´£º
deb http://oss.oracle.com/debian unst ......
¡í1:È¡µÃµ±Ç°ÈÕÆÚÊDZ¾Ôµĵڼ¸ÖÜ
SQL> select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from
dual;
TO_CHAR(SYSDATE,'YY
-------------------
20030327 4 18:16:09
SQL> select to_char(sysdate,'W') from dual;
T
-
4 ......