¹ØÓÚÐÞ¸Ä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£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHAR(25),
  ......
¡öÀÖÖª
“ËÊÇ˵ÄË”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......
oracleÐÐתÁÐͨÓùý³Ì(ת)
»·¾³oracle 10g
¹¤×÷¹ØÏµ,³£×öЩÐÐתÁб¨±í,±¨±íͨ³£²»ÊÇÔÚ´óÊý¾Ý¼¯ºÏÉÏ´¦Àí.
ËùÒÔдÁ˸ö¹ý³Ì.
±¾¹ý³Ì±È½ÏÊʺÏÔÚÓÚÐèÒª¶¯Ì¬Êä³ö±¨±íµÄµØ·½,ÀýÈçwebÖÐ.
²»ÊǺÜÍêÃÀ,µ«ÒѾ¿ÉÒÔ½â¾ö¾ø´ó²¿·ÖµÄÎÊÌâ.
create or replace function func_RowToCol(
viewName Varchar2,
grpCols Varchar2,
colC ......
ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......