ÓÃCodeSmith±àдģ°åµ¼³öOracleÖбíµÄÊý¾Ý 2
ʹÓÃ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
Ïà¹ØÎĵµ£º
Èç¹û˵RedoÊÇÓÃÀ´±£Ö¤ÔÚ¹ÊÕÏʱÊÂÎñ¿ÉÒÔ±»»Ö¸´£¬ÄÇôUndoÔòÊÇÓÃÀ´±£Ö¤ÊÂÎñ¿ÉÒÔ±»»ØÍË»òÕß³·Ïú¡£
ÔÚÐ޸IJÙ×÷ÖУ¬¶ÔÓÚ»ØÍ˶εIJÙ×÷´æÔڶദ£¬ÔÚÊÂÎñ¿ªÊ¼Ê±£¬Ê×ÏÈÐèÒªÔڻعö¶Î±í¿Õ¼ä»ñµÃÒ»¸öÊÂÎñ²Û£¬·ÖÅä¿Õ¼ä£¬È»ºó´´½¨Ç°¾µÏñ£¬´ËºóÊÂÎñµÄÐ޸IJÅÄܽøÐУ¬Oracle±ØÐëÒÔ´ËÀ´±£Ö¤ÊÂÎñÊÇ¿ÉÒÔ»ØÍ˵ġ£
Èç¹ûÓû§Ìá½»ÁËÊÂÎñ£¬Oracle»á ......
oracleµÄÌåϵ̫ÅÓ´óÁË£¬¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÄÑÃâ»áÓÐЩÎÞ´ÓÏÂÊֵĸоõ£¬Ê²Ã´¶¼Ïëѧ£¬½á¹ûʲô¶¼Ñ§²»ºÃ£¬ËùÒÔ°Ñѧϰ¾Ñé¹²Ïíһϣ¬Ï£ÍûÈøոÕÈëÃŵÄÈ˶ÔoracleÓÐÒ»¸ö×ÜÌåµÄÈÏʶ£¬ÉÙ×ßһЩÍä·¡£
Ò»¡¢¶¨Î»
oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracle ......
oracle µÄÔ¼ÊøÖ÷ÒªÊÇÔÚÒµÎñÂß¼²ãÃæά»¤Êý¾ÝµÄÍêÕûÐÔ¡£Ö÷Ҫͨ¹ý³ÌÐòÔ±ÔÚÓ¦ÓóÌÐòÖй涨ԼÊø»òÕßͨ¹ý¶¨Òå´¥·¢Æ÷À´Î¬»¤Êý¾ÝÍêÕûÐÔ£¬×îºóÊÇͨ¹ýʹÓÃoracle×Ô´øµÄÔ¼ÊøÀ´Î¬»¤Êý¾ÝÍêÕûÐÔ¡£ÄÜʹÓÃoracle×Ô´øµÄÔ¼Êø´ïµ½ÒªÇó¾Í¾¡Á¿Ê¹ÓÃoracle×Ô´øµÄÔ¼Êø£¬ÒòΪʹÓô¥·¢Æ÷µÈÓû§×Ô¶¨ÒåÔ¼Êø¶¼»áÓ°ÏìÊý¾Ý¿âµÄÐÔÄÜ¡£ÀýÈ磺ʹÓô¥·¢ ......
1¡¢SQL Óï¾ä»ù´¡
ÏÂÃæ¸ø³öSQLÓï¾äµÄ»ù±¾½éÉÜ¡£
1.1¡¢SQLÓï¾äËùÓ÷ûºÅ
²Ù×÷·û ÓÃ; Àý×Ó
+ - ±íʾÕýÊý»ò¸ºÊý£¬ÕýÊý¿ÉÊ¡È¥ + -1234.56
+ ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼Ó A=c+b
- ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼õ 34-12
* ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà³Ë 12*34
/ ³ýÒÔÒ»¸öÊý»ò±í´ïʽ 18*11
NULL ¿ÕÖµÅÐ¶Ï Where name is null;
......
ÉñÃØµÄ ORACLE DUAL±í
DUAL ? ÓÐʲôÉñÃصÄ? µ±ÄãÏëµÃµ½ORACLEϵͳʱ¼ä, ¼ò¼òµ¥µ¥ÇÃÒ»ÐÐSQL¡¡
¡¡¡¡
¡¡¡¡²»¾ÍµÃÁËÂð? ¹ÊŪÐþÐé….¡¡
¡¡¡¡
¡¡¡¡SQL> select sysdate from dual;¡¡
¡¡¡¡
¡¡¡¡SYSDATE¡¡
¡¡¡¡
¡¡¡¡———¡¡
¡¡¡¡
¡¡¡¡28-SEP-03¡ ......