oracle¸Ä×Ö·û¼¯
. ¼´½«µ¼³ö SCOTT µÄ±íͨ¹ý³£¹æÂ·¾¶...
. . ÕýÔÚµ¼³ö±í BONUSµ¼³öÁË 0 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
. . ÕýÔÚµ¼³ö±í DEPTµ¼³öÁË 4 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
. . ÕýÔÚµ¼³ö±í EMPµ¼³öÁË 14 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
. . ÕýÔÚµ¼³ö±í SALGRADEµ¼³öÁË 5 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
×Ô¼º»úÆ÷ÉÏ×°µÄORACLEÊý¾Ý¿â,µ±Ê±ÉèÖõÄ×Ö·û¼¯ÊÇUTF-8,
µ¼³öʱ³öÏÖÁËÒÔÉϵÄÔÒò,ÎÊÁËÒ»ÏÂÓ¦¸ÃÊÇ×Ö·û¼¯ÎÊÌâ,
×¢²á±íÖÐNLS_LANGµÄÖµÊÇSIMPLIFIED CHINESE_CHINA.ZHS16GBK
SYS²éѯ SELECT * from V$NLS_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';
ËùµÃµÄÖµÊÇAL32UTF8
ÎÒ¸ÄÁË×¢²á±íµÄµÄֵΪÕâ¸öÖµ·¢ÏÖSCOTTÓû§¶¼µÇ²»ÉÏ
ÏÖÔÚµÄÎÊÌâ¾ÍÊÇ,ÎÒÈç¹û²»ÖØ×°ORACLEÈçºÎÉèÖÃ×Ö·û¼¯ÎªGBK?
Èç¹û²»¸Ã×Ö·û¼¯ÎÒÔõôÄܳɹ¦µÄµ¼³öÄØ?
set NLS_LANG=american_america.AL32UT
Ïà¹ØÎÊ´ð£º
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......