Oracle¸ü¸ÄÊý¾ÝÎļþλÖÃ
·½·¨Ò»£ºoffline±í¿Õ¼ä
1¡¢offline±í¿Õ¼ä£ºalter tablespace tablespace_name offline£»
2¡¢¸´ÖÆÊý¾ÝÎļþµ½ÐµÄĿ¼£»
3¡¢renameÐ޸ıí¿Õ¼ä£¬²¢Ð޸ĿØÖÆÎļþ£»
4¡¢online±í¿Õ¼ä£»
1¡¢offline±í¿Õ¼äzerone
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ZERONE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\RMANTS.DBF
ÒÑÑ¡Ôñ7ÐС£
SQL> alter tablespace zerone offline;
±í¿Õ¼äÒѸü¸Ä¡£
2¡¢¸´ÖÆÊý¾ÝÎļþµ½ÐµÄĿ¼
¸´ÖÆÊý¾ÝÎļþC:\ORACLE\PRODUCT\10.2.0\ORADATA\ZERONE01.DBFµ½C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ZERONE01.DBF¡£
3¡¢renameÐ޸ıí¿Õ¼äÊý¾ÝÎļþΪеÄλÖ㬲¢Ð޸ĿØÖÆÎļþ
SQL> alter tablespace zerone rename datafile 'c:\oracle\product\10.2.0\oradata\zerone01.dbf' to 'c:\oracle\product\10.2.0\oradata\orcl\zerone01.dbf';
±í¿Õ¼äÒѸü¸Ä¡£
4¡¢online±í¿Õ¼ä
SQL> alter tablespace zerone online;
±í¿Õ¼äÒѸü¸Ä¡£
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ZERONE01.DBF
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\RMANTS.DBF
ÒÑÑ¡Ôñ7ÐС£
SQL> select file_name,tablespace_name from dba_data_files where tablespace_name='ZERONE';
FILE_NAME TABLESPACE_NAME
------------------------------------------------------------------------------------------------
ZERONE C:\OR
Ïà¹ØÎĵµ£º
Êý¾Ý˵Ã÷Ò»ÇУº
create table dept(deptno number,deptname varchar2(20),mgrno number);
insert into dept values (1, '×ܹ«Ë¾', null);
insert into dept values (2, 'Õã½·Ö¹«Ë¾', 1);
insert into dept values (3, 'º¼ÖÝ·Ö¹«Ë¾', 2);
commit;
select t.* from dept t;
DEPTNO &n ......
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......
1,<>
2,µ¥¶ÀµÄ>,<,(ÓÐʱ»áÓõ½£¬ÓÐʱ²»»á)
3,like "%_" °Ù·ÖºÅÔÚǰ.
4,±íû·ÖÎö.
5,µ¥¶ÀÒýÓø´ºÏË÷ÒýÀï·ÇµÚһλÖõÄË÷ÒýÁÐ.
6,×Ö·ûÐÍ×Ö¶ÎΪÊý×ÖʱÔÚwhereÌõ¼þÀï²»Ìí¼ÓÒýºÅ.
7,¶ÔË÷ÒýÁнøÐÐÔËËã.ÐèÒª½¨Á¢º¯ÊýË÷Òý.
8,not in ,not exist.
9,µ±±äÁ¿²ÉÓõÄÊÇtimes±äÁ¿£¬¶ø±íµÄ×ֶβÉÓõÄÊÇdate±äÁ¿Ê±.»òÏà· ......
¶¨Ò壺
´æ´¢¹ý³Ì£¨Stored Procedure £©ÊÇÒ»×éΪÁËÍê³ÉÌØ¶¨¹¦ÄܵÄSQL Óï¾ä¼¯£¬¾±àÒëºó´æ´¢ÔÚÊý¾Ý¿âÖС£Óû§Í¨¹ýÖ¸¶¨´æ´¢¹ý³ÌµÄÃû×Ö²¢¸ø³ö²ÎÊý£¨Èç¹û¸Ã´æ´¢¹ý³Ì´øÓвÎÊý£©À´Ö´ÐÐËü¡£´æ´¢¹ý³ÌÊÇÊý¾Ý¿âÖеÄÒ»¸öÖØÒª¶ÔÏó£¬ÈκÎÒ»¸öÉè¼ÆÁ¼ºÃµÄÊý¾Ý¿âÓ¦ÓóÌÐò¶¼Ó¦¸ÃÓõ½´æ´¢¹ý³Ì¡£ ´æ´¢¹ý³ÌÊÇÓÉÁ÷¿ØÖƺÍSQL Óï¾äÊéдµÄ¹ý ......