oracle shell±à³ÌʲôÒâ˼°¡£¿
oracle shell±à³ÌʲôÒâ˼°¡£¿ÊDz»ÊǾʹ洢¹ý³ÌʲôµÄ°¡£¿
°Ù¶Èһϣ¬Äã»á¸üÇå³þ¡£¡£¡£¡£ http://www.oracle.com/technology/global/cn/pub/articles/saternos_scripting.html Shell ½Å±¾ÊÇʲô£¿ shell ½Å±¾ÊÇÒ»¸ö°üº¬ÃüÁîÐòÁеÄÎı¾Îļþ¡£µ±ÔËÐÐÎļþ£¨»ò½Å±¾£©Ê±£¬½«Ö´ÐиÃÎļþÖаüº¬µÄÃüÁî¡£ÊõÓï shell ½öÖ¸Óë Linux ÄÚºËͨÐÅËùʹÓõÄÌØ¶¨ÃüÁîÐÐÓû§½çÃæ¡£Ä¿Ç°Óжà¸ö²»Í¬µÄ shell£¬ÆäÖаüÀ¨ C shell (csh)¡¢Korn shell (ksh)¡¢Bourne shell (sh) ºÍ Bourne-Again shell (bash)¡£shell ±¾Éí¾ÍÊÇÒ»¸ö´ÓÎļþ»òÖն˶ÁÈ¡ÃüÁî¡¢½âÊÍÕâЩÃüÁͨ³£Ö´ÐÐÆäËûÃüÁîµÄÃüÁî¡£Bourne-Again shell ºÏ²¢ÁËÉÏÊöÆäËû shell µÄÌØÐÔ£¬±¾ÎľÍʹÓøýű¾½øÐÐÑÝʾ Èç¹ûÄúÕýÔÚ¿¼ÂÇΪһ¸öÐèÒª´óÁ¿Êý¾Ý¿â·ÃÎʵÄÈÎÎñ±àдSHELL½Å±¾£¬Ôò½Å±¾¿ÉÄܲ¢²»ÊÇ×î¼ÑÑ¡Ôñ¡£±¾ÎĵÄÉԺ󲿷ֽ«½éÉÜÈçºÎʹÓà SQL*Plus ·ÃÎÊÊý¾Ý¿â£¬µ«ÔںܶàÇé¿öÏ£¬Ê¹ÓÃÆäËûÓïÑÔ¿ÉÒÔ¸üºÃµØ½â¾ö´ËÎÊÌâ¡£ ϱí¹éÄÉÁË¿ÉÒÔ´ÓÊý¾Ý¿âÖзÃÎʵÄÐÅÏ¢£º ·þÎñÆ÷/²Ù×÷ϵͳÐÅÏ¢ ·þÎñÆ÷±êʶ µäÐͲéѯ ¸½×¢ ʵÀýÔËÐÐÔÚµÄÖ÷»úµÄÃû³Æ select host_name from v$instance; Ò²¿ÉÒÔͨ¹ý´Ó bash ÔËÐÐÒÔÏÂSHELLÃüÁîÀ´»ñµÃ¸ÃÐÅÏ¢£º hostname »ò uname –n ²Ù×÷ϵͳƽ̨ select platform_name from v$database –-(10g) Èç¹ûÔËÐÐ uname –s£¬Ôò½«·µ»ØÀàËÆÐÅÏ¢ ¾ÍÊÇlinux/unixϵÄoracle±à³Ì£¬Í¨¹ý±àдshell½Å±¾¶Ôoracle½øÐе÷ÓÃÒýÓà or
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º 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²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......
ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390 ×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ ×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿ 2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿© ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ £¿ ¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡ Ò»°ã ......
лл ÎÒÒ²ÊÇÏëÖªµÀ me too ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ....... ¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......