ʹÓÃ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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
C ......
28.4.1 ÊÖ¹¤Æô¶¯ºÍ¹Ø±ÕOracle·þÎñ
OracleÊý¾Ý¿â·þÎñÓÉÁ½²¿·Ö×é³É£ºÊý¾Ý¿â½ø³ÌºÍÍøÂç¼àÌýÆ÷½ø³Ì£¬ËüÃÇ·Ö±ð¿Éͨ¹ýsqlplusºÍlsnrctlÃüÁî¿ØÖÆÆô¶¯¹Ø±Õ¡£
1£®Êý¾Ý¿â½ø³Ì
ʹÓÃDBCA¹¤¾ß´´½¨Êý¾Ý¿âºó£¬Æä½ø³ÌÒѾ×Ô¶¯Æô¶¯£¬ÕâЩ½ø³Ì¶¼ÊÇÒÔÊý¾Ý¿âÃû³Æ£¨ÔÚ±¾ÀýÖÐΪorcl£©ÃüÃû£¬ÈçÏÂËùʾ¡£
$ ps -ef|grep orcl
orac ......
²½Ö裺
(1) ´´½¨×÷Òµ
(2) ´´½¨job
dbms_job.submit();
submit ( jobno¡¡OUT binary_ineger,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡What¡¡¡¡¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡next_date IN¡¡date,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡interval¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡ &nb ......