oracle×Ô´øµÄ²Ù×÷ÎļþµÄ°üUTL_FILE½éÉÜ
Òò¿ª·¢ÒªÇó£¬ÐèÒª¶ÔoracleÀïµÄÊý¾ÝÓëÊý¾ÝÎļþ×÷±È½Ï¡£Èç²ÉÓÿͻ§¶ËÁ¬½ÓoracleµÄ·½Ê½ÔòÏÔµÃСÌâ´ó×ö£¬ÇÒ¹¤×÷Á¿´ó£¬²»Ò×ά»¤¡£Ö±½Ó²ÉÓô洢¹ý³Ì£¬µ÷ÓÃUTL_FILE°üµÄ¹«¹²¹ý³Ì£¬ÏԵ÷½±ãµÃ¶à¡£
Ê×ÏÈ£¬ÐèÒª°ÑÊý¾ÝÎļþËùÔÚµÄĿ¼ע²áµ½oracleÖУ¬ÓÃcreate directory¡£¡£¡£Óï¾ä£¬È»ºó°Ñ´ËĿ¼µÄread£¬writeȨÏÞgrant¸ødevelop user account¡£×¢Òâcreate directoryÓï¾äËùÐèÒªµÄȨÏÞ£¬·½±ãµÃ»°Ö±½ÓÓÃdbaÓû§´´½¨directory¡£
Æä´Î£¬Îļþ²Ù×÷ÈçͬC£¬C++£¬JAVAµÈ¸ß¼¶ÓïÑԲ¶à£¬Ö÷ÒªÓÐÕ⼸¸ö·½·¨£º
UTL_FILE.fopen(d_output,v_filename,'r',32767);--32767ºÜ¹Ø¼ü£¬Èç¹ûÎļþÒ»ÐеÄ×Ö½ÚÊý¹ý´ó£¬²»Ö¸¶¨Õâ¸ö²ÎÊý£¬oracleÖ»»á¶ÁÈë×ĬÈϳ¤¶ÈµÄ×Ö·û´®£¬ÒÔÖÁÒ»ÐÐÎı¾µ±³ÉÁË“Á½ÐД¶Á¡£
UTL_FILE.get_line(FILE_HANDLE,v_text);
UTL_FILE.put_line(FILE_HANDLE,v_text);
UTL_FILE.fclose(FILE_HANDLE);
¶ÔÓÚÒª²Ù×÷xlsÎļþ£¬Ò»ÐÐÊý¾Ý²ÉÓÃchr(13)||chr(10)·Ö¸îÿÁеÄÊý¾Ý¡£È±µãÊÇÎÞ·¨½øÐÐxlsµ¥Ôª¸ñµÄһЩ¸ñʽ»¯£¬ÒÔ¼°µ¥Ôª¸ñºÏ²¢µÈ²Ù×÷¡£Òò´ËËäÈ»oracleÓвÙ×÷xlsµÄ»ù±¾¹¦ÄÜ£¬µ«Ö»ÄÜÍê³É×î»ù±¾µÄ¹¦ÄÜ¡£
×îºó£¬¾ÍÊÇ×Ö·û¼¯µÄÎÊÌâÁË£¬ÉÏÃæÌáµ½µÄget_lineº¯Êý£¬ÊÇÒÔ×Ö½ÚΪµ¥Î»µÄ£¬oracleÒ²Óа´ÕÕË«×Ö½ÚÀ´´¦ÀíµÄ¡£µ«ÊǶÔÓÚUTF-8µÄÎı¾£¬Ä³Ð©ºº×ֵıàÂëÊÇÈý¸ö×Ö½Ú£¬Èç¹ûÆäÖÐÒ»¸ö×Ö½ÚΪOA£¬»òOD£¬oracle¾Í»áÎóÈÏΪ´ËÐÐÒѾÖÕÖ¹£¬ÕâÑùÒ²»á°ÑÔ±¾Ò»ÐеÄÄÚÈݵ±³É“Á½ÐДÀ´¶ÁÈ¡¡£oracleµÄ×Ö·û¼¯Îª¼òÌåÖÐÎÄ£¬¿ÉÄÜÊÇoracle·þÎñ¶ËµÄ×Ö·û¼¯²»ÊÇUTF-8²Åµ¼ÖÂÕâ¸öÎÊÌ⣬»¹ÊÇ˵oracle±¾Éí¾Í´æÔÚÕâ¸öÎÊÌ⣬»¹ÓдýÈ·ÈÏÏ£¡
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
oracleÐÐתÁÐͨÓùý³Ì(ת)
»·¾³oracle 10g
¹¤×÷¹Øϵ,³£×öЩÐÐתÁб¨±í,±¨±íͨ³£²»ÊÇÔÚ´óÊý¾Ý¼¯ºÏÉÏ´¦Àí.
ËùÒÔдÁ˸ö¹ý³Ì.
±¾¹ý³Ì±È½ÏÊʺÏÔÚÓÚÐèÒª¶¯Ì¬Êä³ö±¨±íµÄµØ·½,ÀýÈçwebÖÐ.
²»ÊǺÜÍêÃÀ,µ«ÒѾ¿ÉÒÔ½â¾ö¾ø´ó²¿·ÖµÄÎÊÌâ.
create or replace function func_RowToCol(
viewName Varchar2,
grpCols Varchar2,
colC ......
ÎÒÏàÐÅÎÒÃǸÕѧoracle£¬¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬¶¼ÊÇÔÚ±¾µØ½øÐеģ¬Ö»Òª±£Ö¤¼àÌý·þÎñÆô¶¯£¬ÄÇôÎÒÃǾͿÉÒÔÕý³£Ê¹ÓÃsqlplus¶ÔÊý¾Ý¿â½øÐвéѯ£¬µ«ÊǼÙÈçÎÒÃÇÏ£Íûͨ¹ýÔ¶³Ì¶ÔÊý¾Ý¿âÀ´·ÃÎÊÄØ£¬´ËʱÎÒÃǾÍÒª¶Ôoracle¼àÌý½øÐÐÅäÖá£
oracle¼àÌýÅäÖÃÓÐÈý¸öÎļþ£¬ÎªÁË·½±ãÃèÊö£¬ÎÒÓÃserverºÍclientÀ´Çø·Ö£ ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ÏÔʾֵ:07
yyy three digits ÈýλÄê &nbs ......
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the c ......