Oracle²é¿´·ÖÇø±íÐÅÏ¢
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢
ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÐÅÏ¢£ºDBA_PART_TABLES
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íÐÅÏ¢£ºALL_PART_TABLES
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄÐÅÏ¢£ºUSER_PART_TABLES
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºDBA_TAB_PARTITIONS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºALL_TAB_PARTITIONS
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºUSER_TAB_PARTITIONS
ÏÔʾ×Ó·ÖÇøÐÅÏ¢ ÏÔʾÊý¾Ý¿âËùÓÐ×éºÏ·ÖÇø±íµÄ×Ó·ÖÇøÐÅÏ¢£ºDBA_TAB_SUBPARTITIONS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓÐ×éºÏ·ÖÇø±íµÄ×Ó·ÖÇøÐÅÏ¢£ºALL_TAB_SUBPARTITIONS
ÏÔʾµ±Ç°Óû§ËùÓÐ×éºÏ·ÖÇø±íµÄ×Ó·ÖÇøÐÅÏ¢£ºUSER_TAB_SUBPARTITIONS
ÏÔʾ·ÖÇøÁÐ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄ·ÖÇøÁÐÐÅÏ¢£ºDBA_PART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄ·ÖÇøÁÐÐÅÏ¢£ºALL_PART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄ·ÖÇøÁÐÐÅÏ¢£ºUSER_PART_KEY_COLUMNS
ÏÔʾ×Ó·ÖÇøÁÐ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄ×Ó·ÖÇøÁÐÐÅÏ¢£ºDBA_SUBPART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄ×Ó·ÖÇøÁÐÐÅÏ¢£ºALL_SUBPART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄ×Ó·ÖÇøÁÐÐÅÏ¢£ºUSER_SUBPART_KEY_COLUMNS
---------------------------------------------------------------------------------------------------
ÔõÑù²éѯ³öOracleÊý¾Ý¿âÖÐËùÓеĵķÖÇø±í
select * from user_tables a where a.partitioned='YES'ɾ³ýÒ»¸ö±íµÄÊý¾ÝÊÇtruncate table table_name;
ɾ³ý·ÖÇø±íÒ»¸ö·ÖÇøµÄÊý¾ÝÊÇalter table table_name truncate partition p5;
Èç¹ûÎÒÒª½«·ÖÇø±íÖи÷¸ö·ÖÇøµÄÊý¾Ý¶¼Çå¿Õ£¬¿ÉÒÔÓÃtruncate table table_name;Âð£¿
»¹ÊDZØÐë´ÓÍ·Ö´ÐÐ
alter table table_name truncate partition p1; alter table table_name truncate partition p2; alter table table_name truncate partition p3; alter table table_name truncate partition p4; alter table table_name truncate partition p5; alter table table_name truncate partition p6;
´ð:truncate table table_name
ÒýÓõØÖ·:http://database.51cto.com/art/201004/195232.htm
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
Ò»£º»Ø¹ö¶Î¸ÅÊö
¡¡¡¡»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐÅÏ¢¡£Ò»¸öÊÂÎñÖ»ÄÜʹÓÃÒ»¸ö»Ø¹ö¶ÎÀ´´æ·ÅËüµÄ»Ø¹öÐÅÏ¢£¬¶øÒ»¸ö»Ø¹ö¶Î¿ÉÒÔ´æ·Å¶à¸öÊÂÎñµÄ»Ø¹öÐÅÏ¢¡£
»Ø¹ö¶ÎµÄ×÷ÓÃ
¡¡¡¡ÊÂÎñ»Ø¹ö£ºµ±ÊÂÎñÐ޸ıíÖÐÊý¾ÝµÄʱºò£¬¸ÃÊý¾ÝÐÞ¸ÄǰµÄÖµ£¨¼´Ç°Ó°Ïñ£ ......
OracleÓû§¡¢È¨ÏÞ¡¢½ÇÉ«¹ÜÀí
Oracle ȨÏÞÉèÖÃ
Ò»¡¢È¨ÏÞ·ÖÀࣺ
ϵͳȨÏÞ£ºÏµÍ³¹æ¶¨Óû§Ê¹ÓÃÊý¾Ý¿âµÄȨÏÞ¡££¨ÏµÍ³È¨ÏÞÊǶÔÓû§¶øÑÔ)¡£
ʵÌåȨÏÞ£ºÄ³ÖÖȨÏÞÓû§¶ÔÆäËüÓû§µÄ±í»òÊÓͼµÄ´æÈ¡È¨ÏÞ¡££¨ÊÇÕë¶Ô±í»òÊÓͼ¶øÑԵģ©¡£
¶þ¡¢ÏµÍ³È¨ÏÞ¹ÜÀí£º
1¡¢ÏµÍ³È¨ÏÞ·ÖÀࣺ
DBA: ÓµÓÐÈ«²¿ÌØÈ¨£¬ÊÇϵͳ×î¸ßȨÏÞ£¬Ö»ÓÐDBA²Å¿ÉÒÔ´´ ......
oracleÖÐpro*cµÄѧϰ
¡¡Ò» Pro*C ³ÌÐò¸ÅÊö£º
1£®Ê²Ã´ÊÇPro*C³ÌÐò
ÔÚORACLEÊý¾Ý¿â¹ÜÀíºÍϵͳÖУ¬ ÓÐÈýÖÖ·ÃÎÊÊý¾Ý¿âµÄ·½·¨£»
£¨1£© ÓÃSQL*Plus£¬ ËüÓÐSQLÃüÁîÒÔ½»»¥µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£»
£¨2£© ÓõÚËÄ´úÓïÑÔÓ¦Óÿª·¢¹¤¾ß¿ª·¢µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£¬ÕâЩ¹¤¾ßÓÐSQL*froms£¬QL*Reportwriter,SQL*MenuµÈ£»
£¨3£© ÀûÓÃÔÚ ......
MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......