Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

DBAÓ¦¸ÃÕÆÎÕµÄSQLÓï¾ä

1.¹ØÓÚÊý¾Ý¿â¹¹¼ÜÌåϵ
¢Ù±í¿Õ¼äµÄ¼à¿ØÊÇÒ»¸öÖØÒªµÄÈÎÎñ£¬ÎÒÃDZØÐëʱ¿Ì¹ØÐıí¿Õ¼äµÄÉèÖã¬ÊÇ·ñÂú×ãÏÖÔÚÓ¦
ÓõÄÐèÇó£¬ÒÔϵÄÓï¾ä¿ÉÒÔ²éѯµ½±í¿Õ¼äµÄÏêϸÐÅÏ¢¡£
SQL code
SELECT TABLESPACE_NAME,
       INITIAL_EXTENT,
       NEXT_EXTENT,
       MIN_EXTENTS,
       MAX_EXTENTS,
       PCT_INCREASE,
       MIN_EXTLEN,
       STATUS,
       CONTENTS,
       LOGGING,
       EXTENT_MANAGEMENT, -- Columns not available in v8.0.x
       ALLOCATION_TYPE, -- Remove these columns if running 
       PLUGGED_IN, -- against a v8.0.x database
       SEGMENT_SPACE_MANAGEMENT --use only in v9.2.x or later
  from DBA_TABLESPACES
 ORDER BY TABLESPACE_NAME;
¢Ú¶ÔÓÚijЩÊý¾ÝÎļþûÓÐÉèÖÃΪ×Ô¶¯À©Õ¹µÄ±í¿Õ¼äÀ´Ëµ£¬Èç¹û±í¿Õ¼äÂúÁË£¬¾Í½«Òâζ×Å
Êý¾Ý¿â¿ÉÄÜ»áÒòΪûÓÐ¿Õ¼ä¶øÍ£Ö¹ÏÂÀ´¡£¼à¿Ø±í¿Õ¼ä£¬×îÖ÷ÒªµÄ¾ÍÊÇ¼à¿ØÊ£Óà¿Õ¼äµÄ´ó
С»òÕßÊÇʹÓÃÂÊ¡£ÒÔÏÂÊÇ¼à¿Ø±í¿Õ¼äʹÓÃÂÊÓëÊ£Óà¿Õ¼ä´óСµÄÓï¾ä¡£
SQL code
SELECT D.TABLESPACE_NAME,
       SPACE "SUM_SPACE(M)",
       BLOCKS SUM_BLOCKS,
       SPACE - NVL(FREE_SPACE, 0) "USED_SPACE(M)",
       ROUND((1 - NVL(FREE_SPACE, 0) / SPACE) * 100, 2) "USED_RATE(%)",
       FREE_SPACE "FREE_SPACE(M)"
  from (SELECT TABLESPACE_NAME,
               ROUND(SUM(BYTES) / (1024 * 1024), 2) SPACE,
               SUM(BLOCKS) BLOCKS
       &


Ïà¹ØÎĵµ£º

oracle sqlÓïÑÔÄ£ºý²éѯ ͨÅä·ûlikeµÄʹÓý̳Ì

ÔÚWhere×Ó¾äÖУ¬¿ÉÒÔ¶Ôdatetime¡¢char¡¢varchar×Ö¶ÎÀàÐ͵ÄÁÐÓÃLike×Ó¾äÅäºÏͨÅä·ûѡȡÄÇЩ“ºÜÏñ...”µÄÊý¾Ý¼Ç¼£¬ÒÔÏÂÊÇ¿ÉʹÓõÄͨÅä·û£º
%   Áã»òÕß¶à¸ö×Ö·û
_    µ¥Ò»ÈκÎ×Ö·û£¨Ï»®Ïߣ©
\     ÌØÊâ×Ö·û
[]     ÔÚijһ·¶Î§ÄÚµÄ×Ö·û£¬Èç ......

×î½üµÄÁ½ÌõsqlЧÂÊÓÅ»¯ÐĵÃ

µÚÒ»Ìõ£º
select * from where field in (1,2,3)   ÕâÖÖд·¨Ó¦¸ÃÉáÆúÁË£¬¶øÓ¦¸ÃÕâÑùд£º
select * from table where field = 1 or field = 2 or field = 3 
ÎªÊ²Ã´ÄØ£¿
·²ÊÂÖ»ÓÐ×ö¹ý²ÅÖªµÀ£¬×Ô¼º½¨¸ö±í£¬²åÈë10WÌõ²âÊÔÊý¾Ý£¬ÓÃsql²âÊÔһϱãÖª£¬ÒòΪ¹¤×÷±ãÀû£¬ÎÒÔÚ²úÆ·»úºÍÍâÍø²âÊÔ»ú¶¼ÒѾ­²âÊÔ¹ý£ ......

SQL learning

Five basic search conditions are summarized here:
1) Comparison test
2) Range test
3) Set membership test
4) Pattern matching test (Like)
     The pattern matching test checks to see whether the data value in a column matches a specified pattern
   % mathes any se ......

SQL Lite

SQL Lite
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
It is a open source product and can be downloaded from http://www.sqlite.org/ . SQL Lite is best suited in Smart Client architecture, where we can locally store all ......

±¾ÈËдµÄµÚÒ»¸öPL/SQL¹ý³Ì

¿´µ½±ðÈËÔÚÂÛ̳µÄÌáÎÊ£º
Ò»¸ö±íµÄЧÂÊÎÊÌâ
½ñÌìÅöµ½2Õűí
1ÕÅ ÓÐ×Ö¶Î
±íAÓÐ
jtbh(¼ÒÍ¥±àºÅ) hzxm(»§Ö÷ÐÕÃû) hnbh(»§ÄÚ×î´ó±àºÅ) 
1000          ÕÅÈý            03
1001          ÕÔÁù..........................
±í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ