Oracle¶ÔĿ¼Îļþ(directory)µÄ¶Áд²Ù×÷
Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬ÀýÈç:
grant read, write on directory exp_dir to eygle;
´ËʱÓû§eygle¾ÍÓµÓÐÁ˶ԸÃĿ¼µÄ¶ÁдȨÏÞ¡£
ÀýÈç:
µ±ÓÃSCOTT½øÐÐĿ¼´´½¨µÄʱºò,Ê×ÏÈÓ¦¸Ã¸³¸øSCOTT´´½¨Ä¿Â¼µÄȨÏÞ,Èç¹ûûÓÐÔò»á±¨Ò»Ï´íÎó
SQL> create or replace directory MY_DIR as 'd:\test';
create or replace directory MY_DIR as 'd:\test'
ORA-01031: ȨÏÞ²»×ã
SQL> GRANT CREATE ANY DIRECTORY TO scott;--ÊÚȨ¸øSCOTTÓû§´´½¨Ä¿Â¼È¨ÏÞ
Grant succeeded
SQL>create or replace directory MY_DIR as 'd:\test';--´´½¨ÁËÒ»¸öĿ¼ÃûΪ'MY_DIR'µÄĿ¼,ËûµÄ·¾¶ÊÇ'd:\test'
Directory created.
SQL>select * from all_directories;--²é¿´´´½¨µÄĿ¼
OWNER DIRECTORY_NAME DIRECTORY_PATH
SYS MY_DIR d:\test
SQL> drop directory my_dir;--ɾ³ýĿ¼
Directory dropped
дÈëÎļþ:
SQL> DECLARE
2 filehandle utl_file.file_type;
3 begin
4 filehandle := utl_file.fopen('MY_DIR','test.txt','w');
5 utl_file.put_line(filehandle,'test 1 write one.');
6 utl_file.put_line(filehandle,'ÄãºÃ!');
7 utl_file.fclose(fil
Ïà¹ØÎĵµ£º
¾¹ýÁ½ÌìµÄµ¹ÌÚÖÕÓÚÔÚmacÉÏ×°ºÃoracle10g ÁË¡£ÕâÏÂÍêÃÀÁË++
½Ì³ÌÍøÉÏÓкܺã¬×Ô¼ºÒ²²»¼ÇµÃ²ÎÕÕ¹ý¶àÉÙÆªÁË¡£
Ö»¼ÇÏÂ×Ô¼ºÅöµ½µÄÎÊÌâµã¡£
1,×éÎÊÌâ¡£
ÍêÈ«ÊǸöÈËʹÓã¬ËùÒÔÎÒûÓл¨ÄǸöÏй¤·òȥн¨Ò»´ó¶Ñ×éºÍÓû§£¬
Ïà·´£¬ÎÒ¾ÍÊÇÄõ±Ç°Óû§×°µÄ£¬Ö»²»¹ý£¬°Ñµ±Ç°Óû§Ò²¼ÓÈëÁËROOT×飬Õâ¸ö±È½ÏºÝ¡£
2£¬ÓеĽ ......
µÍ³É±¾»ñÈ¡OracleÏà¹ØÈÏÖ¤£¬È«Ãæ¿ìËÙÕÆÎÕOracle¼¼Êõ
ÔÚÆóҵȺÌåÖУ¬È«Çò500Ç¿£¬ÓÐ98%ÔÚʹÓÃOracle¼¼Êõ£»È«ÇòÊ®´óÒøÐоù²ÉÓÃÁËOracleÓ¦ÓÃϵͳ£¬ÔÚÖйú£¬ÅÅÃûǰ20λµÄÒøÐж¼ÔÚʹÓÃOracle¼¼Êõ£»ÔÚͨÐÅÁìÓò£¬È«Çò20¼Ò¶¥¼¶Í¨ÐŹ«Ë¾È«²¿¶¼ÔÚʹÓÃOracleÓ¦ÓòúÆ·¡£ÔÚÖйú£¬ËùÓеĵçÐÅÓªÔËÉ ......
£±£º´´½¨»·¾³±äÁ¿
¡¡¡¡export $ORACLE_HOME $ORACLE_SID£¨×¼±¸½¨Á¢µÄÊý¾Ý¿âµÄSID)
£²£º½¨Á¢³õʼ»¯²ÎÊýÎļþ
¡¡¡¡$ORACLE_HOME/dbs/init$ORACLE_SID.ora (¿ÉÒÔ´ÓÒѾ½¨ºÃµÄ¿âÀïÃæÄÃ,ͨ³£ÔÚpfile ÀïÃæ£©,Ò²¿ÉÒÔ×Ô¼º½¨£º
¡¡¡¡control_files = ($ORACLE_HOME/oradata/$ORACLE_SID/control1.ctl,$ORACLE_HOME/oradata/$ORACLE ......
1 ²éѯsqlÓÅ»¯
1.1 Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò£¨Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧORACLE£©
½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí¡£ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí ......
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......