Çë½Ì ѧϰORACLEÊé¼®
ÓÐÄÄЩÊé¼®ÊÇѧϰoracle¿ª·¢±È½ÏºÃµÄÊé¼®£¿
Oracle9iHelp Oracle10gSQLRef Oracleר¼Ò¸ß¼¶±à³Ì ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éOracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£© »ù´¡µÄ£º Oracle 10g ÈëÃÅÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩 OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g ½ø½×·½ÃæµÄ£º oracleʵÓü¼ÊõÏê½â Oracle 9i/10g±à³ÌÒÕÊõ Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯ ×îÈ«ºÍ×îȨÍþµÄ£º oracle×Ô´øÎĵµÒýÓà »ù´¡µÄ£º Oracle 10g ÈëÃÅÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩 OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g ½ø½×·½ÃæµÄ£º oracleʵÓü¼ÊõÏê½â Oracle 9i/10g±à³ÌÒÕÊõ Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯ ×îÈ«ºÍ×îȨÍþµÄ£º oracle×Ô´øÎĵµ up... ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 ¡¶Oracle DBA Åàѵ½Ì³Ì¡· ¡¶Oracle Database 10g SQL¿ª·¢Ö¸ÄÏ¡· ¡¶ÉîÈë½âÎöOracle——DBAÈëÃÅ¡¢½ø½×ÓëÕï¶Ï°¸À
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£ ²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ? ûÓÐÁªÏµµÄ exp, imp ÎÒÒª°ÑÆäÖеÄÁ½ ......