ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
ÒòΪÄã°ÑÎļþ¼Ð¿´´íÁ˰ɡ£
´ó¸ç£¬Èç¹û²»ÊÇÄãÑÛ»¨µÄ»°£¬ÄÇ¿ÉÄܾÍÊÇÄã½ø´íµØ·½ÁË¡£
ÓÃÈýÂ¥µÄ·½·¨²éһϾÍÖªµÀÊÇʲôÁË
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£
ÕûÈËÓÐÒâ˼Â𣿡¡ÖªµÀ´ð°¸Ö±½Ó·¢ÉÏÀ´¹²Í¬Ñ§Ï°¡£¡¡Ñ§Ï°ÒªÇ«Ð飬¡¡Ã¿È˶¼ÓÐ×Ô¼ºµÄÓŵ㡣¡¡±ðÈËÈÈÐĵİïÄ㣬»¹³ö¿ÚÂîÈË£¬ÓÖ¼ûÒ»¸ö¸öÐÔµÄ90ºó£¬ ÕæÎÞÓïѽ.. ÒÔºó»¹ÏëÔÚÕâÀï»ì£¬×îºÃÇ«Ðéµã..
liuxinyu19901016
ÏȰÑÕâÌù¶¥ÆðÀ´£¬Èôó¼Ò¶¼ÈÏʶÈÏʶÄã.. liuxinyu19901016
¹þ¹þ
90ºó¡¡
ʲô½ÐÖªµÀ´ð°¸£¬ÕâÊǺóÀ´Ñ§Ï°²éÕÒ¸ãÃ÷°×µÄ¡£Ê²Ã´½ÐÎÒÑÛ¾¦ÓÐÎÊÌ⣬²»ÖªµÀ¾ÍÊDz»ÖªµÀ»¹ÓýƱçÂð£¿ÎÞÓï¡£¡£¡£¡£¡£
ºÇºÇ
ºÍг ÂÛ̳ÐèÒªºÍг
1
¼´±ãÊÇÄãºóÀ´×Ô¼ºÍ¨¹ýѧϰ¸ãÃ÷°×ÁË Ò²ÒªÀ´ºÍ´ó¼Ò·ÖÏíÒ»ÏÂѽ ÔõôÄÜÖ»Îʲ»·ÖÏíÄØ ¶Ô²»¶Ô ÂÛ̳¾ÍÊÇÒ»¸ö´ó¼Ò»¥°ï»¥Öú¹²Ïí֪ʶµÄµØ·½
2
¼´±ãij¸öÈË˵´íÁË»° ÄãÒ²²»ÄÜ˵´ó¼Ò¶¼ÊÇÖí°É ºÇºÇ
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......
ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390
×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ
×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......