win 7ÎÞ·¨°²×°oracle¿Í»§¶Ë£¬Çë¸ßÊÖÖ¸µã
ÈçÌ⣬ÎÒµÄÊÇHP 4411S£¬²»ÖªµÀÓë»úÆ÷ÓÐûÓйØÏµ£¬ÎÒͬʵÄIBMµÄ¾Í¿ÉÒÔ°²×°ÉÏ£¬ÎÒÓÃËüµÄoracle¿Í»§¶Ë°²×°³ÌÐò¶¼²»ÄÜÔËÐУ¬²»ÖªÊÇɶÔÒò£¬»¹ÓÐÎÒ»»ÁíÒ»¸ö°æ±¾µÄoracle¿Í»§¶Ë°²×°³ÌÐòʱ£¬°²×°³É¹¦£¬µ«°²×°PL/SQL DeveloperºóËÀ»îµÇ¼²»ÉÏ£¨×¢£ºtnsnames.oraÒѾÅäÖã©£¬³öÏÖÒ»¸ö¿´²»³ÉÈκÎ×ÖµÄÌáʾ¿ò£¬Ö»ÓÐÒ»¸öÈ·¶¨°´Å¥£¬Çë¸÷λ´óÏÀ°ïæ~
WIN 7¼æÈÝÎÊÌâ?
×°µÄÊÂORACLE¼¸°æ±¾µÄ
Èí¼þ°æ±¾¿ÉÄÜÓÐÎÊÌ⣬win7³öÀ´Ê±¼ä²»³¤£¬¹À¼ÆOracle »¹Ã»ÓÐÍÆ³öORACLE for win7.
Â¥Ö÷¿ÉÒÔÕÒÒ»¸övista °æ±¾µÄOracle ×°ÊÔÊÔ..
Oracle»¹Ã»Óа汾֧³Öwindows 7°¡¡£
http://www.oracle.com/technology/software/products/database/index.html
Ö»ÒªÕÒ¸öÖ§³ÖVistaµÄ°æ±¾¾Í¿ÉÒÔÁË¡£
ÊǶàÉÙλµÄ»úÆ÷ѽ¡£
64bitµÄ»°£¬È·ÊµÓÐÎÊÌâ¡£ ÎÒÒÔǰҲûÓи㶨¹ý
˵¿ìÁË£¬²»ÊÇ»úÆ÷ÊǶàÉÙbitµÄ£¬ÊÇϵͳÊǶàÉÙλµÄ£¬64bitµÄϵͳȷʵdev×°ÉÏ£¬ÔËÐв»ÁË¡£
ÄãÊÖ¶¯ÔÚplsql devÀïÖ¸¶¨Ò»ÏÂoracle home
¸Ðл¸÷λÈÈÐÄÅóÓѵÄÁôÑÔ°ïÖú£¬ÎÒ´Ó¹Ù·½ÉÏÔØÁËÒ»¸öoracle client for vista°æ±¾µÄ£¬Ò»ÇÐ˳ÀûµÄ°²×°ÉÏÁË£¬¿ÉÒԺúøÐÊÜÒ»ÏÂWIN 7ÁË¡£
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡
¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡
Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......