oracleÂÒÂëÎÊÌâ
oracleÅ׳öµÄ´íÎóÏÖÔÚÊÇÂÒÂ루ÖÐÎÄÎÄ×Ö£©£¬ÈçºÎ°ÑÕâЩÖÐÎÄÎÄ×Ö±ä³É²»ÊÇÂÒÂ룬ÓõÄ×Ö·û¼¯ÊÇUTF8µÄ¡£
ÔÚÄÄÀﱨ´íÊÇÂÒÂëѽ¡£sqlplus»·¾³À»¹ÊdzÌÐòÀï¡£
ÔÚP/LSQLÀï̫̾£¿ºÃÏñ˵µÄ²»Ì«Ïêϸ°¡
ÔÚBATÖе÷ÓÃSQLÎļþµÄʱºò£¬Éú³ÉµÄLOGÎļþµ±ÖУ¬ÕâÀïÃæ¼ÙÈçÅ׳öORACLEµÄϵͳÒì³£µÄʱºò£¬ÖÐÎľͻáÂÒÂ룬Êý¾Ý¿â±àÂëÊÇUTF8µÄ¡£
Set ErrLogFile_TSQL= C:\_TSQL_ERR.LOG
sqlplus %UserId%/%PassWord%@%DatabaseName% @C:\WCL_ODR_PROC.sql > %ErrLogFile_TSQL%
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 25 13:39:02 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
???:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Session altered.
[SQLLDR_ERROR]PROPERTY ERROR.Error converting data type varchar to
datetime.[Receive_Date]
ÕâÀïÃæ¾ÍÊÇLOGÎļþÖеÄÄÚÈÝ£¬ ???: ÕâЩÖÐÎľÍÊÇÂÒÂ룬²»ÖªµÀÈçºÎ½â¾ö£¬
ÎÒÏÖÔÚÊÇÕâÑù½â¾öµÄ£¬²»¹ý²»ÊÇÌ«ºÃ£¬¾ÍÊÇÔÚSQLÎļþÖе÷Óô洢¹ý³Ì֮ǰ£¬°Ñ ´òLOGµÄÐÅÏ¢µÄÖÐÎÄת»¯³ÉÁË Ó¢ÎÄ£¬¼ÓÁËÕâÑùµÄÒ»¾ä»°¡£
alter session set nls_language=american;
»¹ÓÐÆäËûµÄ½â¾ö°ì·¨Âð
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......