oracle¿ª·¢µÄÏà¹ØÎÊÌâ - Oracle / ¿ª·¢
×öOracleÊý¾Ý¿â¿ª·¢µÄ´óÏÀÄÜ˵˵Oracle¿ª·¢µÄÖ÷Òª¹¤×÷ÒÔ¼°Ïà¹Ø¹¤¾ßÂð£¿
ÒªÊÇÏë×öºÃOracle¿ª·¢Ó¦¸Ã¾ß±¸Ê²Ã´ÄÜÁ¦ÄØ£¿
лл£¬Ï£Íû´ó¼ÒÓ»Ô¾ÌÖÂÛ£¡
Õâ¸öÎÊÌâºÃÏñÖ»ÄÜ×öÕâ¸öµÄ²ÅÖªµÀÁË¡£¡£¡£°ïlz¶¥¡£¡£¡£ºÙºÙ¡£¡£
˳±ãת¸öÐÁ¿à·Ö¡£¡£¡£¡£ºÇºÇ¡£¡£
ÓëÊý¾Ý¿âÏà¹ØµÄ¹¤×÷£º³ÌÐòÔ±¡¢dbaµÈ
Ïà¹Ø¹¤¾ß£ºsqlplus¡¢pl/sql developer¡¢toad¡¢powerdesigner......
ÄÜÁ¦£ºÐèÒªÒ»¶¨µÄ×ÔѧÄÜÁ¦£¬¼á³Ö²»Ð¸
ÎҵŤ×÷Ò»°ã¾ÍÊÇд´æ´¢¹ý³Ì£¬ÓÅ»¯SQL£¬ºÍÊý¾ÝЧÑéÖ®ÀàµÄ¡£
ÎÒÓõÄÊÇPL/SQL DEV£¬ÓÐЩÈËϲ»¶ÓÃTOAD¡£
Òª»ù±¾¾ß±¸µÄÄÜÁ¦¾ÍÊÇÄÜдƯÁÁµÄSQLÓï¾ä£¬»¹Òª»á¿´Ö´Ðмƻ®µÈµÈ¡£
ÔÚÉϰ࣬û¶àÏ룬ÏÂÃæ¼ÌÐø²¹³ä
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......