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

oracleÎ÷Å·×Ö·û¼¯

oracle·þÎñÆ÷¶Ë²ÉÓõÄÊÇÎ÷Å·×Ö·û¼¯:AMERICAN_AMERICA.WE8ISO8859P1£¬ÎÒÔÚ³ÌÐòÀï²éѯ³öÀ´ºóÊÇÂÒÂë
Çë¸ßÊÖ°ïæ

ÔÚÏßµÈ... 


ÔÚ³ÌÐòÀïÖ¸¶¨ÏàͬµÄ×Ö·û¼¯¿ÉÐУ¿

ÔÚ³ÌÐòÀïÖ¸¶¨ÏàͬµÄ×Ö·û¼¯£¬½«»á·Ç³£µÄ·±Ëö
ÓÐûÓÐÆäËüµÄ°ì·¨

ÄãÊÇÓõÄʲô³ÌÐò£¬jdbc thin£¬jdbc oci£¬ occi»¹ÊÇÆäËû±¾µØ¿âµÄ·½Ê½?

Èç¹ûÊÇjdbc thin£¬ÐèÒª°Ñ½á¹û¼¯×ªÂëÖÁISO-8859-1£¬Èç¹ûÊÇociÕâÑùµÄ±¾µØ¿âµ÷Óõķ½Ê½µÄ·½Ê½£¬ÐèÒªÉèÖÃNLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1


Ïà¹ØÎÊ´ð£º

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

OracleÈçºÎʹÓô°¿Úº¯ÊýʵÏÖÕâÑùµÄ²éѯ

±í¼Ç¼
======================================
name        date        score
Fei Zhang  1          100
Fei Zhang  ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

visual c#ÎÞ·¨Á¬½Óoracle£¿£¿£¿

´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺

δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......

oracle impdpÎÊÌâ

Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôԭÒò,ÇëÖ¸½Ì....  лл'


Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39016: Operation not supported when job is in EXECUTING ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ