ÔõÑù¸øÒѽ¨oracle±í´´½¨·ÖÇø
˵Ã÷£ºÎÒÓиöoracle±íchanpinÊý¾ÝÔ½À´Ô½´ó£¬Ïë´´½¨¸ö·ÖÇø£¬°´ÕÕ×Ö¶Îvip£¨ÖµyesÊǸ߼¶»áÔ±£¬noÊÇÆÕͨ»áÔ±£© ÎÒÓà SQL code: create table chanpin (id number,vip varchar2(8)) ¡¡¡¡partition by list(vip)( ¡¡¡¡partition t_list_vipcp values ('yes') tablespace vip01, ¡¡¡¡partition t_list_novipcp values ('no') tablespace novip01); ²»ÄÜ´´½¨£¬ÒòΪchanpin±í´æÔÚ Óà SQL code: alter table chanpin add partition by list(vip)( ¡¡¡¡partition t_list_cipcp values ('yes') tablespace vip01, ¡¡¡¡partition t_list_novipcp values ('no') tablespace novip01); Ò²²»ÐУ¬ÇëÎʸÄÔõô¼û·ÖÇø°¡£¿Ð»Ð»
ORACLEÎÞ·¨Ö±½Óת»»¡£ ÏȽ¨Á¢Ò»¸ö½á¹¹Ò»Ä£Ò»ÑùµÄ·ÖÇø±í£¬È»ºóʹÓÃÁª»úÖØ×éµÄ·½Ê½£¬½«ÏÖÓÐÊý¾Ý×°ÔØ½øÐµķÖÇø±í£¬È»ºóÖØÃüÃû¡£ ¿ÉÒÔ°ÑÔ±í¸Ä¸öÃû×Ö,ÔÙн¨Õâ¸ö±í(´ø·ÖÇø),ÔÙ°ÑÊý¾Ý¿¼½üÀ´ÒýÓà ORACLEÎÞ·¨Ö±½Óת»»¡£ ÏȽ¨Á¢Ò»¸ö½á¹¹Ò»Ä£Ò»ÑùµÄ·ÖÇø±í£¬È»ºóʹÓÃÁª»úÖØ×éµÄ·½Ê½£¬½«ÏÖÓÐÊý¾Ý×°ÔØ½øÐµķÖÇø±í£¬È»ºóÖØÃüÃû¡£ ͬÒâ лл¥Éϻشð
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸öupdateÓï¾ä update table_a A set A.flag=1 where A.id in (select B.id from table_b B) ½á¹ûÎóд³É update table_a A set A.flag=1 where ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸö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£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......