ORALCE8£¬Ò»¸öÒѾ´æÔڵĿ⣬ÎÒÁ¬½Ó×öÍøÕ¾¿ª·¢¡£
¸Õ×°ºÃµÄʱºòÖÐÎÄÏÔʾÂÒÂ룬Ȼºó°´ÕÕ´ó¼Ò˵µÄ¸ÄÁË×¢²á±íÀïÃæµÄnls_lanΪUS7ASCIIºó
toadÁ´½Ó²éѯÏÔʾÖÐÎÄÕý³£¡£
ÏÖÔÚÓÃVS2008¿ª·¢£¬Êý¾Ý°ó¶¨³öÀ´ÏÔʾµÄʱºò¾Í»¹ÊÇÂÒÂëÁË£¬ÕâÎҾ͸㲻Ã÷°×ÁË¡£¡£¡£
ÐÂÊÖ¸Õѧoracle£¬»¹Çë´ó¼ÒÖ¸µãһϡ£¡£¡£
alter session set ......
ORALCE8£¬Ò»¸öÒѾ´æÔڵĿ⣬ÎÒÁ¬½Ó×öÍøÕ¾¿ª·¢¡£
¸Õ×°ºÃµÄʱºòÖÐÎÄÏÔʾÂÒÂ룬Ȼºó°´ÕÕ´ó¼Ò˵µÄ¸ÄÁË×¢²á±íÀïÃæµÄnls_lanΪUS7ASCIIºó
toadÁ´½Ó²éѯÏÔʾÖÐÎÄÕý³£¡£
ÏÖÔÚÓÃVS2008¿ª·¢£¬Êý¾Ý°ó¶¨³öÀ´ÏÔʾµÄʱºò¾Í»¹ÊÇÂÒÂëÁË£¬ÕâÎҾ͸㲻Ã÷°×ÁË¡£¡£¡£
ÐÂÊÖ¸Õѧoracle£¬»¹Çë´ó¼ÒÖ¸µãһϡ£¡£¡£
ÂÒÂë¶¼ÊÇÓɱàÂë¸ñʽ² ......
ÔËÐл·¾³£ºMyEclipse8.5+Oracle 11g
ÔÚWEB-INF/libÎļþ¼ÐϵÄJDBCÇý¶¯£º
ojdbc5.jar;
ojdbc5_g.jar;
ojdbc6.jar;
ojdbc6_g.jar;
ÔÚMETA-INFÎļþ¼ÐϵÄÊý¾ÝÔ´ÅäÖÃÎļþcontext.xml:
<Context reloadable="true">
<Resource name="jdbc/bookstore" auth="Container"
......
ÎÒÔÚlinux²Ù×÷ϵͳÉÏ ½øÈë²»ÁË oracleµÄ²Ù×÷½çÃæ
ÊÇÖ¸µÄem dbconsoleô¡£
http://so.csdn.net/BlogSearchResult.aspx?q=dbconsole%20username:inthirties
ÎÒ²Åѧϰoracle ÇëÎÊemÊÇʲô£¿£¿£¿£¿ÎÒÔÚÍøÉÏûÓв鵽¡«¡«
¿´ÁËÉÏÃæÁ¬½ÓûÓÐ
ÊÇÒ»¸öoracleµÃͼÐλ¯µÃ¹ÜÀí½çÃæ
¿´ oracledbconsole·þÎñÆðÁËûÓÐ
......
ʹÓÃhibernateÓ³ÉäÎļþÅäÖÃÊý¾Ý¿â±íµÄ¹ØÏµ£¬Ö´ÐÐʱ±¨£ºSQL ÃüÁîδÕýÈ·½áÊø ´íÎó
ºÜÃ÷ÏԵĴíÎó£¬SQLÓï·¨´íÎó£¬Ìù³ö´úÂë²ÅÖªµÀÔΪ¡£
SQLÓï·¨´íÎó --ÌṩµÄÐÅϢ̫ÉÙ£¬Ïë°ïÄãҲûÕÞ
Hibernate: select informatio0_.×ÊѶ±àºÅ as ×ÊѶ±àºÅ2_, informatio0_.ÐÅÏ¢ÀàÐÍ1 as ÐÅÏ¢ÀàÐÍ2_2_, informatio0_.ÐÅÏ¢ÀàÐÍ2 as ......
ÇëÎÊ¿ÉÒÔÔÚµ¼Èëµ¼³öµÄʱºò,Ö¸¶¨²»µ¼Èëijһ¸ö±íÂð
ºÃÏñ²»ÐÐ
Â¥Ö÷¿ÉÒÔÖ¸¶¨³ýÁ˸ñíÍâµÄËùÓбí
µ«ÊÇÎÒµ¼ÈëµÄ±íºÜ¶à,¾ÍÒ»¸ö±í²»Ïëµ¼Èë,ÒòΪÕâ¸ö±íÌ«´óÁË
userid=zhjusr/zhjusr
buffer=4096000
file=smapdb_online_20081029.dmp
STATISTICS=none
TABLES=(MP_QUOTA_DAY_TAB,MP_TAB)--ÔÚ´ËÓû§¿ÉÒÔÖ¸¶¨Òªµ¼³öµÄ ......