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

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Êý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ