ÔÚLinuxϰ²×°ÍêOracle10g£¬¸ÃÔõôÓ𡣿
ÔÚLinuxϰ²×°ÍêOracle10g£¬¸ÃÔõôÓ𡣿
ÎÒÏë´´½¨Ò»¸öÊý¾Ý¿â£¬ÔÚÔõô´´½¨°¡£¿
ÒÔ¼°ÎÒÏëÓÃͼÐλ¯¹¤¾ßÀ´²Ù×÷Oracle£¬¸ÃÔõô°ì£¿
SQL code:
1¡¢×°ÍêÁ˾ÍÒѾÓÐÊý¾Ý¿âÁË¡£
2¡¢ÓÃlinuxµÄoracleÓû§µÇ½µ½Í¼ÐνçÃæÏµÍ³
3¡¢´ò¿ªÒ»¸öÖÕ¶Ë
4¡¢ÔÚÖÕ¶ËÀïÃæÇÃÏÂÃæµÄÃüÁîÆô¶¯Êý¾Ý¿â
1)sqlplus / as sysdba
2)startup
5¡¢ÔÙ¿ªÒ»¸öÖÕ¶Ë£¬ÇÃÈëÈçÏÂÃüÁîÆô¶¯¼àÌýºÍoem
1)Æô¶¯¼àÌý
lsnrctl start
2)Æô¶¯oem·þÎñ
emctl start
×¢Òâoem·þÎñÆô¶¯ºó»áÓÐÒ»¸öÍøÖ·µÄÌáʾ£¬ÀûÓÃÕâ¸öÍøÖ·¾Í¿ÉÒÔͨ¹ýieÓÃͼÐνçÃæ²Ù×÷oracleÁË
˳Ðò²»Òª´íÁË£¬´íÁË»áÓÐÎÊÌâ¡£
**********
¸üÕýһϣº
**********
2)Æô¶¯oem·þÎñ
emctl start dbconsole
±§Ç¸£¬Ð´µÄ¿ìÁËЩ¡£¡£¡£
ÇÃÈësqlplus / as sysdba Ëü˵ÊÇÎÞЧÃüÁî°¡
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÔÚLINUXÉÏÓÐÁ½¸öÓû§
Ò» root
¶þ myadmin
¡¾myadmin@localhost~¡¿$ dir
Desktop myphp
[myadminlocalhost~]$ cd myphp¡¢DesktopÄܽøÈ¥ÆäËûµÄϵͳĿ¼½ø²»È¥
Ö»ÓÐÕâÁ½¸öĿ¼ ÎÒÏë½øÈëÆäËûµÄÏ ......
ÓÐʲôºÃµÄLinux½Ì³ÌÂð£¿
СµÜл¹ý~
[ÎÊÌâµãÊý:0·Ö]
google
¾Ý˵Äñ¸çµÄ˽·¿²Ë²»´í¡£
Äñ¸çµÄLinux˽·¿²Ë
¸ü¶àµÄÔÙÕâÉÏÃæÈ¥ËÑË÷һϺÜLIUNXÊé¼®»¹²»´í
ÒýÓÃ
google
Õý½â
Äñ¸çµÄLinux˽·¿²Ë ......