Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚÐÞ¸Ä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 %
%:¿ÉÒÔÊäÈëÒª²é¿´²ÎÊýµÄ²¿·ÖÃû³Æ,×Ô¶¯ÏÔʾƥÅäµÄ²ÎÊý


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle×ÔÔöIDʵÏÖ

Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
       CREATE TABLE example(
             ID Number(4) NOT NULL PRIMARY KEY,
             NAME VARCHAR(25),
    ......

¡¶Í¿Ä¨Oracle£­Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç

¡öÀÖÖª
  “Ë­ÊÇË­µÄË­”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾­µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......

¡¾×ª¡¿oracleÐÐתÁÐͨÓùý³Ì

oracleÐÐתÁÐͨÓùý³Ì(ת)
»·¾³oracle 10g
¹¤×÷¹ØÏµ,³£×öЩÐÐתÁб¨±í,±¨±íͨ³£²»ÊÇÔÚ´óÊý¾Ý¼¯ºÏÉÏ´¦Àí.
ËùÒÔдÁ˸ö¹ý³Ì.
±¾¹ý³Ì±È½ÏÊʺÏÔÚÓÚÐèÒª¶¯Ì¬Êä³ö±¨±íµÄµØ·½,ÀýÈçwebÖÐ.
²»ÊǺÜÍêÃÀ,µ«ÒѾ­¿ÉÒÔ½â¾ö¾ø´ó²¿·ÖµÄÎÊÌâ.
create or replace function func_RowToCol(
viewName Varchar2,
grpCols Varchar2,
colC ......

ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)

ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ