ORACLE°²×°Íê±Ï»¹ÒªÅäÖû·¾³±äÁ¿£¿
< <Oracle 10 g±¦µä>>ÊéÉÏ˵ΪÁËÄܹ»ÔÚ²»Ìṩ·¾¶µÄÇé¿öÏÂÖ±½ÓÔËÐлòµ÷ÓÃoracleÓ¦ÓóÌÐò£¬°²×°Íê³Éºó£¬Ó¦¸ÃÔÚ»·¾³±äÁ¿£¨ÏµÍ³±äÁ¿£©pathºÍ perl5libµÈÖÐÌí¼ÓÏàÓ¦µÄ·¾¶
Õâ¸ö»¹ÐèÒªÕâôÅäÖ𡣿
windows
ÎҵĵçÄÔ--¡·ÊôÐÔ--¡·¸ß¼¶--¡·»·¾³±äÁ¿
linux
½øÈëÓû§Ä¿Â¼ /home/user
eg:
home/oracle
ÔÚÓÃvi Ö±½Ó±à¼
vi .profile
SQL code:
[oracle@hfcc]$ vi .profile
export PATH=$PATH:$ORACLE_HOME/bin
²»Å䵱ȻҲ¿ÉÒÔÁË..
ÅäÖúóϵͳ¾Í»áͨ¹ýpathÀïȥѰÕÒÁË..·½±ã..
ºÃµÄtiÈÕ
Ïà¹ØÎÊ´ð£º
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......