ÇëÎÊOracleÊý¾Ý¿â´æ´¢¹ý³ÌÖÐ:=ÊÇʲôÒâ˼
ÄܾÙÀý˵Ã÷Âð£¬Ð»Ð»´ó¼Ò
Ϊ±äÁ¿£¬³£Á¿¸³Öµ·ûºÅ лл´ó¼ÒÒýÓà ÄܾÙÀý˵Ã÷Âð£¬Ð»Ð»´ó¼Ò Õý½âÒýÓà Ϊ±äÁ¿/³£Á¿¸³Öµ·ûºÅ¡£ declare v_id number; v_name varchar2(16); c_status CONSTANT char(1) := '1'; begin v_id := 777; v_name := 'ACÃ×À¼'; ¡¡ end; Õý½â up ¼ÓÓÍ ¡£¡£ ¸³Öµ ¾ÍÊǸ³ÖµµÄ¹¦ÄÜ Ò»¡¢SQL PLUS 1 ÒýÑÔ SQLÃüÁî ÒÔÏÂ17¸öÊÇ×÷ΪÓï¾ä¿ªÍ·µÄ¹Ø¼ü×Ö£º alter drop revoke audit grant rollback* commit* insert select comment lock update create noaudit validate delete rename ÕâЩÃüÁî±ØÐëÒÔ¡°;¡±½áβ ´ø*ÃüÁî¾äβ²»±Ø¼Ó·ÖºÅ£¬²¢ÇÒ²»´æÈëSQL»º´æÇø¡£ SQLÖÐûÓеÄSQL*PLUSÃüÁî ÕâЩÃüÁî²»´æÈëSQL»º´æÇø @ define pause # del quit $ describe remark / disconnect run accept document save append edit set break exit show btitle get spool change help sqlplus clear host start column input timing compute list ttitle connect newpage undefine copy --------- 2 Êý¾
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸö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£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÊÌâÌá³ö£º Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ ¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬ A B 1 2 2 3 3 4 4 ÓÐÕâÑùһЩÊý¾Ý ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý COLA COL1 COL3 COL2 COL1 4 4 ......