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

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

ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0Îҽṹ£¬Ã»ÓÐʹÓÃ3.0ÖеÄ×Ô¶¯ÊôÐÔ¡£
CodeSmith Professional 5.0.1.4983  
ÒªÇó×Ô¼º½¨Á¢Ò»¸öOracleSchemaPrivider,Á¬½Óµ½ÄãµÄoracleÊý¾Ý¿â£¬Ñ¡ÔñÒ»¸ö±í¡¾Éú³É¡¿
view plaincopy to clipboardprint?
<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a very simple business object." ResponseEncoding="UTF-8" %>  
<%@ Property Name="DevelopersName" Type="String" Category="Context" Default="dacong" Description="×÷Õß" %>  
<%@ Property Name="Suffix" Type="String" Category="Context" Default="Info" Description="ÀàÃûºóê¡" %>  
 
<%@ Property Name="NameSpace" Type="String" Category="Context" Default="dacong" Description="The namespace to use for this class,²»°üÀ¨Model" %>  
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the object is based on." %>  
<%@ Assembly Name="SchemaExplorer" %>  
<%@ Assembly Name="System.Data" %>  
<%@ Import Namespace="SchemaExplorer" %>  
<%@ Import Namespace="System.Data" %>  
/****************************************************************************** 
 ---------------------------------------------------------------- 
  Ä£¿éÃû³Æ: <%= GetClassName(SourceTable) %>[Ä£ÐÍ] 
  ±àÕß    : <%=DevelopersName %>        ´´½¨ÈÕÆÚ: <%=DateTime.Now.Date.ToString("yyyyÄêMMÔÂddÈÕ")%> 
  ¹¦ÄÜÃèÊö:  
 ---------------------------------------------------------------- 
  ÐÞ¸ÄÈÕÆÚ:&n


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM

28.5  OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔ­À´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄÜ ......

ORACLE ÐÐתÁÐ ²âÊÔͨ¹ý£¨9i£©

--ORACLE ÐÐתÁР ²âÊÔͨ¹ý£¨9i£©
/***************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶®
***********************************************************************************************************/
--1¡¢ÐÐתÁÐ
......

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

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