¹ØÓÚÐÞ¸ÄoracleµÄ²ÎÊý
Ê×ÏÈÄØ¿Ï¶¨ÊÇÒªÒÔÊý¾Ý¿â¹ÜÀíÔ±µÄÉí·Ý½øÈë Ò²¿ÉÒÔÔÚ·þÎñÆ÷ÉÏÃæÒÔÏÂÃæµÄ·½Ê½Á¬½Óµ½Êý¾Ý¿â:
´ò¿ªcmd´°¿Ú,sqlplus /nolog
½øÈëÃüÁîÐкó,conn / as sysdba
¿ªÊ¼Ð޸IJÎÊý
alter system set key=[value] scope=[scope];
key: ÒªÐ޸ĵIJÎÊý
[value]:ÒªÉèÖõÄÖµ,ÊýÖµÐ͵ÄÖ±½ÓÌîÈëʹÓÃÊý×Ö,×Ö·ûÐ͵ÄÒªÓõ¥ÒýºÅÀ¨ÆðÀ´
[scope]:ÓÐ3¸öÑ¡ÔñmemoryÖ¸µÄÊÇÖ»Ð޸ĵ±Ç°ÔËÐÐʵÀýµÄ²ÎÊý,ÖØÆôÊý¾Ý¿âºó»Ö¸´ÒÔǰµÄÉèÖÃ;spfileÐ޸ijõʼ»¯ÎļþÖеÄÉèÖÃ,ÖØÆôÊý¾Ý¿âºóÉúЧ;bothͬʱÐÞ¸ÄÔËÐÐʵÀýºÍ³õʼ»¯ÎļþµÄÉèÖÃ.
Ð޸IJÎÊýʱ,¿ÉÄÜ»á³öÏÖÕâ¸ö´íÎó
ORA-02095: ÎÞ·¨ÐÞ¸ÄËùÖ¸¶¨µÄ³õʹ»¯²ÎÊý
ÐÞ¸Ä[scope]ֵΪspfile,¼´¿É
²é¿´²ÎÊý
show parameter %
%:¿ÉÒÔÊäÈëÒª²é¿´²ÎÊýµÄ²¿·ÖÃû³Æ,×Ô¶¯ÏÔʾƥÅäµÄ²ÎÊý
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
28.6 Oracle³£¼ûÎÊÌâ´¦Àí
±¾½Ú½éÉÜÔÚRed Hat Enterprise Linux 5.2Éϰ²×°¼°ÅäÖÃOracleÊý¾Ý¿â·þÎñÆ÷ÖУ¬³£¼ûµÄÎÊÌâ¼°½â¾ö·½·¨£¬°üÀ¨ÈçºÎ»ñµÃÊý¾Ý¿â´´½¨¹ý³ÌÖеÄÏêϸÐÅÏ¢£¬·ÃÎÊOEM³öÏÖ“°²È«Á¬½Óʧ°Ü£¬Ê¹ÓÃÁËÎÞЧµÄ°²È«Ö¤Êé”´íÎóÒÔ¼°Íü¼ÇsysÓû§¿ÚÁîºóµÄ´¦Àí·½·¨µÈ¡£ ......
²½Ö裺
(1) ´´½¨×÷Òµ
(2) ´´½¨job
dbms_job.submit();
submit ( jobno¡¡OUT binary_ineger,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡What¡¡¡¡¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡next_date IN¡¡date,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡interval¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡ &nb ......
oracleÐÐתÁÐͨÓùý³Ì(ת)
»·¾³oracle 10g
¹¤×÷¹ØÏµ,³£×öЩÐÐתÁб¨±í,±¨±íͨ³£²»ÊÇÔÚ´óÊý¾Ý¼¯ºÏÉÏ´¦Àí.
ËùÒÔдÁ˸ö¹ý³Ì.
±¾¹ý³Ì±È½ÏÊʺÏÔÚÓÚÐèÒª¶¯Ì¬Êä³ö±¨±íµÄµØ·½,ÀýÈçwebÖÐ.
²»ÊǺÜÍêÃÀ,µ«ÒѾ¿ÉÒÔ½â¾ö¾ø´ó²¿·ÖµÄÎÊÌâ.
create or replace function func_RowToCol(
viewName Varchar2,
grpCols Varchar2,
colC ......