oracleä¯ÀÀÆ÷·ÃÎÊÆóÒµ¹ÜÀíÆ÷ʲôҲûÓÐ
ͨ¹ýä¯ÀÀÆ÷·ÃÎÊÆóÒµ¹ÜÀíÆ÷£¬Ò³Ãæ¿Õ°×£¬Ö»ÓÐ×óÉϽÇÓÐÆæ¹ÖµÄͼ°´£¬ÓеãÏñÂÒÂëÄÇÖֵģ¬ÎªÊ²Ã´»áÕâÑù£¿ÎҶ˿ڶ¼Ð´¶ÔµÄ
ÊÇ·ÃÎÊemô¡£
¿ÉÒÔhttp:\\host:1158\em
¶Ë¿ÚÒ²ÓпÉÄÜÖ¸¶¨ÆäËûµÄ¶Ë¿ÚÁË
¿ÉÒÔÔÚ%ORACLE_HOME%\install\portlist.iniÖп´¿´
ÕâÖÖÇé¿öÎÒÒ²Óöµ½¹ý,µ±Ê±ÊǶ˿ÚÕÒ´íÁ˵¼ÖµÄ.
grid control ÖÐÐÒéÒªÊÇhttps ·ñÔòÒ²»áÓÐÕâÖÖÎÊÌâ.
¿ÉÄÜÊÇʲôµØ·½ÅäÖò»¶ÔÁË£¬°ïÂ¥Ö÷¶¥ÁË£¬×Ô¼ºÒ²Ã»ÓÐÓöµ½¹ý
ÎÒÏëÆðÀ´ÁË£¬ÒÔǰÓÃWin2000µÄʱºò£¬ÓÉÓÚä¯ÀÀÆ÷°²È«ÐÔÌ«¸ß¶øÃ»Óа취ʹÓÃEM£¬²»ÖªµÀÂ¥Ö÷µÄÊDz»ÊÇÕâÖÖÇé¿ö¡£
portlist.iniÖеÄÄÚÈÝÈçÏ£¬ÎÒдµÄ1158¶Ë¿Ú£¬Ó¦¸ÃÊǶԵÄ
Ultra Search HTTP ¶Ë¿ÚºÅ =5620
Enterprise Manager Console HTTP ¶Ë¿Ú (orcl) = 1158
Enterprise Manager ´úÀí¶Ë¿Ú (orcl) = 3938
ä¯ÀÀÆ÷°²È«¼¶±ðµ÷µ½×îµÍÁËÒ²»¹ÊÇÕâÑù
ºÃÆæ¹Ö£¬×°µÄʱºòҲû¸Äʲô
ÎÒÖØÐÂ×°ÁËһϣ¬ÕâÏ·ÃÎÊÊÇһƬ¿Õ°×£¬°´ÕÕÂ¥ÉϵÄ×öÁËһϣ¬Ã»ÓÐÈκÎЧ¹û
ÎÒÖÕÓÚ¿´µ½ÆóÒµ¹ÜÀíÆ÷µÄµÇÂ½Ò³ÃæÁË£¬µ«ÊÇÎÒÓÐÒ»¸öÒɻ󣬾ÍÊÇÎÒÊÇÓõØÖ·£ºhttps://machinename:1158/em/console/aboutApplication·ÃÎʲſ´µ½µÄ
Ϊʲôֱ½ÓÓãºhttps://machinename:1158/em/µØÖ··ÃÎʵÄʱºòһƬ¿Õ°×£¿¶øÎÒÓÃoracle10gµÄʱºò¾Í¿ÉÒÔÖ±½ÓÓõڶþ¸öµØÖ··ÃÎÊѽ£¿ºÃÆæ¹Ö£¬ÊÇÒòΪÎÒÊǸհ²×°Ã»ÓÐн¨ÆäËû·ÇϵͳÓû§µÄÔµ¹ÊÂð£¿
ѧϰ
ÏÖÔÚ³öÏÖÒ»¸öеÄÎÊÌ⣬ÎÒÔÚsql/plusÀïÃæÓÃsysÓû§µÇ½ÊÇ¿ÉÒԵ쬵«ÊÇÔڵǼEnterprise ManageMentʱȴ²»ÐУ¬¿´µ½ÍøÉÏ˵ÔڵǼEnterprise ManageMentʱҪÓÃsysmanÓû§µÇ½£¬¿ÉÊÇÒ²µÇ²»½øÈ¥£¬ÃÜÂëÊÇûÓиĹý£
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
±¾À´ÒªÐ´¸ö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 ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ã ......
Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡
¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡
Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......