OracleÅàѵ֮Âà ÉÇÍ·
Õâ´ÎÈ¥ÉÇÍ·ÊǸøÉÇÍ·µçÐŽ²¿Î,Ö÷½²ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯,ΪÆÚ4Ìì.´ÓÂÞºþÆû³µÕ¾³ö·¢,×ßÉîÉǸßËÙ,´óÔ¼4,5¸öÖӾ͵½ÉÇÍ·ÁË.
³ö·¢Ê±ÊÇ°øÍí,³µ×ÓÔÚÉîÉǸßËÙÐнø,ϦÑôÎ÷Ï£¬ÂäÈÕµÄÓà»ÔÕÕÓ³ÔÚ¹«Â·Á½±ßµÄÇðÁê,ɽÌÁÉÏ£¬¿´ÉÏÈ¥ºÜÃÀ¡£ÉîÉǸßËٴ󲿷ÖÊÇÑØן£°¶ÏßòêÑÑ£¬ËùÒÔ£¬ÓÐʱÔÚ³µÉϾÍÄܹ»¿´µ½º££¬ÂäÈÕµÄÓà»ÔÕÕÔÚ´óº£ÉÏ£¬²¨¹âÁÛÁÛ£¬¼ÓÖ®º£·çÏ°Ï°£¬ÊÇÎÒϲ»¶µÄÄÇÖָоõ¡£ÎÒûÓÐÐÄ˼¹Û¿´³µÉϵĵçÓ°£¬´ó²¿·Öʱ¼äÎÒ¶¼ÊÇ´ò¿ª³µ´°£¬±¥ÀÀº£°¶·ç¹â¡£¹«Â·Á½±ßºÜ¶àСɽ£¬²»¸ß£¬µ«¿´ÉÏÈ¥ºÜºÃÍ棬ºÃ±È¼ÒÏçºóÃæµÄСɽ£¬Ð¡µÄʱºòÎÒÃǾ³£ÅÀÉÏÈ¥Í棬»òÔÚɽÆÂÀïÍæÈüÅÜ£¬¿´ËµÚÒ»¸ö´ÓɽÏÂÅܵ½É½¶¥£¬´Óɽ¶¥Åܵ½É½ÎÑ¡£Í¯ÄêµÄ»¶ÀÖÏÖÔÚºÜÄÑÖØÊ°£¬ÎÒÖ»ÄÜÒÐ×ųµ´°£¬³Á½ûÔÚͯÄ껶ÀֵĻØÒäÖС£
½øÈëÉÇÍ·ÊÐÇø£¬ÓÃæÒ²ÊÇÒ»×ùбÀË÷´óÇÅ£¬ÉÇÍ·µçÐŵÄÖì¿¡·åÖ÷ÈÎÔÚ³µÕ¾µÈºò¶àʱ£¬Ê±¼äÒÑÊÇÍíÉÏ9µã¶àÁË£¬ÎÒÃÇÔÚÒ»¼Ò²ÍÌü³ÔÍê·¹£¬ÖìÖ÷ÈξͿª³µËÍÎÒµ½Áúºþ±ö¹Ý¡£
ÉÇÍ·µçÐŵÄÅóÓÑ£¬²Î¼Ó´Ë´ÎÅàѵµÄ¶¼±È½ÏÄêÇᣬ¹À¼ÆºÜ¶à´Ó´óѧ±ÏÒµ³öÀ´Ã»¶à¾Ã£¬ËùÒÔÎÊÌâÒ²ÌرðµÄ¶à£¬¿ÎÌÃÆø·ÕÈÈÁÒ£¬ÓÐʱ²îµãû°ÑÎÒ¸ãÃÉ¡£ºÇºÇ£¬ÄêÇáÈË×ÜÊǺÜÓм¤Ç飬¼ÇµÃÔÚ½²ORACLE SQLÓÅ»¯Ê±£¬ºÜ¶àѧԱֱ½Ó½«ËûÃÇƽʱ¾õµÃºÜÂýµÄÎÊÌâSQL·¢¸øÎÒ£¬ÈÃÎÒÇÐÇÐʵʵµØÌå»áµ½ÁËÏÖ³¡×öÓÅ»¯µÄ¹¤×÷Æø·Õ¡£¿É±ðС¿´ÕâЩÄêÇáС»ï×Ó°¡£¬ËûÃǸø³öµÄÎÊÌâÄѶȶ¼²»Ð¡ÍÛ£¬¸Õ´ÓѧУ³öÀ´£¬»¹´ø×ÅÄǹɴòÆÆɳ¹øÎʵ½µ×µÄѧϰ¾¢¶ù¡£ºÇºÇ£¬²»¹ý£¬ËûÃÇÒ²ÓÐһЩ±¦¹óµÄÍæÒâ¶ù£¬ÓÐÒ»¿î¿ÉÒÔÔÚ¾ÖÓòÍøÄÚ·Ö·¢ÎļþµÄÈí¼þ£¬½Ð“·É¸ë´«Ê锣¬ÒÔ¼°Ò»¿î¿ÉÒÔ´Ó¸÷¸öÖն˿´µ½ÀÏʦµÄµçÄÔÆÁÄ»µÄ½ÌѧÈí¼þ£º“HtScreen”,ÎÒ¾õµÃ¾ÍÌرðµÄºÃ£¬ÎÒÌØÒ⿽ÏÂÀ´ÁË£¬ËäÈ»ÊǵÁ°æ£¬µ«ÎÒ¾ö¶¨ÔÚÎÒÒÔºóµÄ¿ÎÌÃÉϲÉÓÃÕâ¿îÈí¼þ(ÎÒ֮ǰ²ÉÓÃNetMeeting£¬µ«Î¢ÈíµÄÕâ¸ö¶«¶«ÔÚÁ¬½ÓÓû§¶àÁ˵ÄÇé¿öÏ£¬²Ù×÷ÌرðµØÂý£¬ÐÔÄܲ»ºÃ¡£¶øHtScreenÔòÊÇÇáÁ¿¼¶µÄ£¬ËüÏ൱ÓÚ½«ÀÏʦµÄÖն˹㲥³öÈ¥£¬¼´Ê¹50¸öѧԱÁ¬½ÓÉÏÄãµÄµçÄÔ£¬Ò²¸Ð¾õ²»µ½±äÂý).
×ÜÌåÀ´½²£¬Õâ´ÎµÄÅàѵʵսЧ¹ûÊÇ×îºÃµÄ£¡Ð¡»ï×ÓÃÇѧµÃÆð¾¢£¬Ïû»¯ÎüÊÕÒ²¿ì¡£µçÐŵÄÖìÖ÷ÈÎÓÐÒâ½øÐеÚ2´ÎÕâÑùµÄÅàѵ¡£
ƽ³£ÎÒÊÇÔÚÁúºþ±ö¹Ý³Ô·¹£¬¾ÆµêµÄ¸÷ÖÖ¸÷ÑùµÄµãÐĵ¹Ê±ºÜ¶à£¬Ê²Ã´Óã½Èѽ£¬ÓãÍèѽ£¬Å£ÈâÍèѽ£¬³¦·ÛµÈµÈ£¬¾Ý˵¶¼ÊÇÉÇÍ·µÄÌØɫС³Ô£¬¿ÉÊÇûÓÐÀ±Î¶£¬ºÜÓе㲻ºÏÎҵĿÚζ¡£ÓÚÊÇÍí²ÍÒ»°ãÊÇÖìÖ÷ÈνÓÎÒµ½ÍâÃæ³Ô¡£ÎÒÃÇ¿ª³µµ½º£±õ·£¬´ó¸Åÿ¸ö±õº£µÄ³ÇÊж¼»áÓйۺ£³¤ÀÈ°É£¬ÉÇÍ·Ò²²»ÀýÍâ¡£ÎÒÃÇÑ¡ÁËÒ»¼Ò¿¿º£±ßµÄ²ÍÌü£¬ÔÚ¶þÂ¥£¬»ù
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
v$processÊÓͼ:
v$processÊÓͼ°üº¬µ±Ç°ÏµÍ³oracleÔËÐеÄËùÓнø³ÌÐÅÏ¢¡£³£±»ÓÃÓÚ½«oracle»ò·þÎñ½ø³ÌµÄ²Ù×÷ϵͳ½ø³ÌIDÓëÊý¾Ý¿âsessionÖ®¼ä½¨Á¢ÁªÏµ¡£
³£ÓÃÁУº
ADDR£º½ø³Ì¶ÔÏóµØÖ·
......
oracle 9i online documentation:
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
oracle 10g online documentation:
http://www.oracle.com/pls/db102/homepage
oracle 11g online documentation:
http://www.oracle.com/pls/db111/homepage ......
ÔÚ´¦ÀíÊý¾Ýʱ·¢ÏÖÒ»¸öÎÊÌ⣬Oracle¶ÔÓÚСÓÚ1µÄСÊý£¬Ð¡ÊýµãÇ°ÃæµÄ0ÊDz»ÏÔʾµÄ¡£
SQL> create table t1_number (num number);
Table created
SQL> insert into t1_number values(0.3268);
1 row inserted
SQL> insert into t1_number values(0.57965686);
1 row inserted
&nb ......