28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü
28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü
ËäÈ»OracleÊý¾Ý¿âÊÇÒ»Ì×ÉÌÒµÈí¼þ£¬µ«ÊÇÓû§¿Éͨ¹ýOracle¹Ù·½ÍøÕ¾http://www.oracle.comÃâ·ÑÏÂÔØOracleÊý¾Ý¿âµÄ°²×°°üÎļþ¡£µ«ÔÚÏÂÔØÇ°ÐèÒªÏÈ×¢²áÒ»¸öÓû§Õ˺ţ¬²¢ÇÒ²»ÄܰÑÏÂÔØµÃµ½µÄOracleÈí¼þÓÃÓÚÉÌÒµÓÃ;£¬Èçͼ28.1Ëùʾ¡£
ͼ28.1 ÏÂÔØOracle 11g
Ñ¡ÔñÏÂÔØ“Oracle Database 11g Release 1 (11.1.0.6.0) for Linux x86”£¬°²×°°üÎļþÃûΪlinux_11gR1_database_1013.zip£¬ÒÔzip¸ñʽѹËõ£¬ÏÂÔØºó°ÑÎļþ±£´æµ½/tmp/Ŀ¼Ï¡£
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
1¡¢pfile Îı¾Îļþ client¶Ë²ÎÊýÎļþ£»²»Äܶ¯Ì¬Ð޸ģ¬¿ÉÒÔÓÃÆÕͨµÄ±à¼Æ÷Ð޸ģ¬ÐÞ¸ÄÖ®ºóÐèÒªÖØÆô¡£pfile¿ÉÄܻᵼÖ·þÎñÆ÷Æô¶¯²»Ò»Ö£¬ÒòΪ¿ÉÒÔÔÚ¿Í»§¶ËÆô¶¯¡£ 2¡¢spfile ¶þ½øÖÆÎļþ·þÎñÆ÷¶Ë²ÎÊýÎļþ£¬ÓÐÁËspfile£¬oracle¿ÉÒÔʵÏÖ¶¯Ì¬²ÎÊýÔÚÏßÐ޸쬲¿·Ö²ÎÊýÐÞ¸ÄÖ®ºóÎÞÐèÖØÆô¡£µ«ÊÇ£¬ÒòΪÊǶþ½øÖÆÎļþ£¬ËùÒÔ²»ÄÜÓÃÆÕͨµÄ±à¼ ......
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡¡¡¡¡¡RETURN ......
µÚ28Õ Oracle·þÎñÆ÷ÅäÖú͹ÜÀí
ÌáÆðÊý¾Ý¿â£¬µÚÒ»¸öÏëÆðµÄ¹«Ë¾Ò»°ã¶¼»áÊÇOracle¡£Oracle¹«Ë¾ÓÚ1977Äê³ÉÁ¢£¬×¨×¢ÓÚÊý¾Ý¿â²úÆ·µÄ¿ª·¢£¬ÔÚÊý¾Ý¿âÁìÓòÒ»Ö±¶¼´¦ÓÚÁìÏȵØÎ»£¬Æä²úÆ·¸²¸ÇÁË´ó¡¢ÖС¢Ð¡ÐÍ»úµÈÊýÊ®ÖÖ»úÐÍ£¬ÊÇĿǰÊÀ½çÉÏʹÓÃ×î¹ã·ºµÄ¹ØÏµÊý¾Ý¿âϵͳ֮һ¡£±¾½ÚÒÔÆä×îеÄÊý¾Ý¿â²úÆ·Oracle 11gΪÀý£¬½éÉÜÈçºÎÔÚRed ......