oracle 10°²×°µÄÎÊÌâ
³õѧoracle ÇëÎÊϰ²×°oracleÊDz»ÊDZØÐëÔÚ´øÍøÂçÁ¬½ÓµÄµÄÌõ¼þϰ²×°£¿ËÞÉáûÁªÍø£¬Ã¿´Î°²×°¶¼µ½79%×óÓҾ͵¯³ö°²×°½áÊø£¬Ã»ÓÐconfiguration assistant ÅäÖùý³Ì£¬Í˳ö°²×°Ò²Ã»Óе¯³öÊý¾Ý¿âµÇ½½çÃæ¡£ ÔËÐÐSQL PLUS ÎÞ·¨µÇ½£ºÎÞ·¨½âÎöÖ¸¶¨×Ö·û Çë¸ßÈ˽âÊÍÏ····
²»ÐèÒªÁªÍø¼´¿É°²×°£¬¿ÉÒÔ¿´ÏÂÈÕÖ¾Îļþ ºÃÏñÊÇÓÐÕâ¸öÎÊÌâ¡£ÎÒÒÔǰҲÓöµ½¹ý¡£×°¸övmÀ´×öʵÑéÓ´¡£ÒýÓà ºÃÏñÊÇÓÐÕâ¸öÎÊÌâ¡£ÎÒÒÔǰҲÓöµ½¹ý¡£×°¸övmÀ´×öʵÑéÓ´¡£ ÎÒ×öÌì×°Á˸ö ÐéÄâÍø¿¨£¬ÎÊÌâÒÀ¾É···· ²»ÓÃÁªÍøÒ²¿ÉÒÔ°²×°µÄ Èç¹ûûÓа²×°ÍêÈ«µÄ»°£¬¹À¼ÆÊǰ²×°ÎļþµÄÎÊÌâ¡£¡£¡£½¨ÒéÖØÐÂÏÂÔØÒ»¸ö°²×°ÎļþÀ´ÊÔÊÔ ¿ªÊ¼-->³ÌÐòÀïÓÐOracle - OraDbX_home1µÄ»°£¬ÊÖ¹¤°²×°Êý¾Ý¿âÊÔÊÔ LZÇ뱨ÄãµÄϵͳ»·¾³£¬ºÍoracle¾ßÌå°æ±¾ºÅ ÎÒн¨ÁËÒ»¸ö´¿×ÖĸÕË»§ °²×°ÁËÐéÄâÍø¿¨ È»ºóжװËùÓÐOracle²úÆ· ɾ³ýHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ServicesÀïûÕÒµ½ORACLEÏà¹Ø È»ºóÖØÆôɾ³ýC:\Oracle ÔÙ°²×° ¾Í³É¹¦ÁË···
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
SQL code: declare v_deptno number(2); v_dname varchar2(14); begin dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:'); v_deptno:=&deptno; v_dname:='&dname'; insert into dept01(deptno,dnam ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......