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

hibernate.cfg.xml¹ØÁªOracleÊý¾Ý¿âµÄÅäÖÃ

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE hibernate-configuration (View Source for full doctype...)>
- <!-- Generated by MyEclipse Hibernate Tools.
--> - <!-- ÒÔÉϼ¸ÐÐËùÓеÄhibernate.cfg.xml¶¼Ïàͬ
--> [url=file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/hibernate.cfg.xml#]-[/url] <hibernate-configuration>
[url=file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/hibernate.cfg.xml#]-[/url] <session-factory>
- <!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄURLÒÔ¼°ÒªÁ¬½ÓµÄÊý¾Ý¿â
--> <property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:sryx</property>
- <!-- Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû
--> <property name="connection.username">yf</property>
- <!-- Á¬½ÓÊý¾Ý¿âµÄÃÜÂë
--> <property name="connection.password">yf</property>
- <!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÇý¶¯
--> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
- <!-- Ö¸¶¨Á¬½ÓµÄÊý¾Ý¿âÀàÐÍ
--> <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
- <!-- JDBC´ÓÊý¾Ý¿âÿ´Î¶ÁÈ¡µÄ¼Ç¼Êý 100»¹½«ÓÅ»¯
--> <property name="jdbc.fetch_size">50</property>
- <!-- JDBCÖ´ÐÐÅúÁ¿É¾³ý£¬¸üУ¬²åÈëʱÿ´Î²Ù×÷µÄ¼Ç¼Êý 30µ½50°É
--> <property name="jdbc.batch_size">50</property>
- <!-- connectionÊÇ·ñ¹ö¶¯½á¹û¼¯
--> <property name="jdbc.use_scrollable_resultset">true</property>
- <!-- ÔÚÉú³ÉµÄSQLÓï¾äÖвúÉú×¢ÊÍ
--> <property name="use_sql_comments">true</property>
- <!-- Á¬½ÓSQLSERVER2000ÓÃ
<session-factory name="java:/hibernate/HibernateFactory"> <property name="show_sql">true</property> <property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property> <property name="connection.url">jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=hibernate_test</property> <property name="c


Ïà¹ØÎĵµ£º

ORACLE SQLÐÔÄÜÓÅ»¯

ORACLE SQLÐÔÄÜÓÅ»¯
ÎÒÒª½²µÄÌâÄ¿ÊÇOracle SQLÐÔÄÜÓÅ»¯£¬Ö»ÊÇOracleÐÔÄÜÓÅ»¯ÖеÄÒ»Ïî¡£OracleµÄÐÔÄÜÓÅ»¯°üº¬ºÜ¶à·½Ã棬±ÈÈçµ÷ÕûÎïÀí´æÈ¡£¬µ÷ÕûÂß¼­´æÈ¡£¬µ÷ÕûÄÚ´æÊ¹Ó㬼õÉÙÍøÂçÁ÷Á¿µÈ¡£ÕâÀïÑ¡ÔñSQLÐÔÄÜÓÅ»¯ÊÇÒòΪÕⲿ·ÖÄÚÈÝÎÒÃDzâÊÔÈËÔ±×îÈÝÒ×½Ó´¥µ½£¬ÁíÍ⿪·¢ÈËԱдSQL½Å±¾Ê±ÓÐʱºÜËæÒ⣬²»Öª²»¾õ¾Í»áÔì³É³ÌÐòÐÔÄÜÉϵÄÏ ......

oracleÍⲿ±í£¨External Table£©µÄʹÓÃ

Ô­ÎĵØÖ·£ºhttp://arvinnan.javaeye.com/blog/308638
²Î¿¼
http://www.blogjava.net/wxqxs/archive/2008/10/13/237180.html?opt=admin
http://hi.baidu.com/ray315/blog/item/153c97a33cd26caacbefd0de.html
 
 
 
¶¨Òå
External tables access data in 
external s ......

oracle Ö®ËÄÁ½²¦Ç§½ï ÃîÕк¯Êý

1.»ñÈ¡µÇ½Óû§µÄÖ÷»úÃû
        select sys_context('userenv','host') from dual;
2.»ñÈ¡µÇ½Óû§µÄIPµØÖ·
        select sys_context('userenv','ip_address') from dual; ......

Oracle»¥»»×ܽá

Oracle»¥»»×ܽá
1. ¶àÐл»³ÉÒ»ÐÐ
    col1  col2            col1  col2
    a       1
    a       2     ת»»ºó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ