¹ØÓÚORACLE×Ö·û¼¯
ÏÂÃæÕâ¶Î»°:
¿Í»§ÖÕ¶Ë×Ö·û¼¯£¬nls_lang»·¾³±äÁ¿×Ö·û¼¯£¬Êý¾Ý¿âʹÓõÄ×Ö·û¼¯¡£ÆäÖУ¬¿Í»§Öն˸÷ÖÖ¸÷Ñù£¬±ÈÈçwindowsÏÂcmd£¬unix/linuxÏÂterminal/console,ÉõÖÁÈçtoadµÈ¹¤¾ßÒ²¿ÉÒÔÀí½âΪһ¸öÖÕ¶Ë¡£ÎÒÃÇʹÓÃwindows cmd¾ÙÀý˵Ã÷£¬cmdʹÓÃÁËgbk±àÂ루ºÃÏñ²»ÄÜÐÞ¸Ä
ºì×ÖµÄ ¿Í»§¶Ë×Ö·û¼¯ ºÍ NLS_LANG×Ö·û¼¯ËûÃÇÁ©Ê²Ã´¹ØÏµ?ÔõôÀí½â?
ÎÒĿǰÈÏΪ¿Í»§¶Ë×Ö·û¼¯¾ÍÊÇNLS_LANG×Ö·û¼¯.
µ«ÊÇ¿´Á˺ܶàÎÄÕÂÒÔºó¸Ð¾õ²»ÊÇÎÒÀí½âµÄÑù×Ó,ÔÚÏßµÈ,лл.
windowÀï¿ÉÒÔÓÃchcp²é¿´×Ö·û¼¯£¬ÕâÀïµÄ×Ö·û¼¯ÊÇÄãconsoleÀïµÄ±¾ÉíµÄ×Ö·û¼¯£¬ÊÇϵͳcmd¹¤¾ß±¾ÉíµÄ×Ö·û¼¯
¶øÄãÕâÀï˵µÄOracleµÄ¿Í»§¶ËµÄ×Ö·û¼¯²»ÊÇÕâ¸öÒâ˼£¬OracleµÄ¿Í»§¶ËÐèÒªÉèÖÃ×Ö·û¼¯£¬
ÔÚwindowÀï¿ÉÒԲ鿴Oracle×¢²á±í£¬ÆäÖеÄNLS_LANG¾ÍÊÇÄãʹÓÃsqlplus»òÕßÊÇplsql devʱµÄ¿Í»§¶Ë×Ö·û¼¯
ÔÚlinuxºÍunixÀï¿ÉÒÔÉèÖÃNLS_LANGµÄ»·¾³±äÁ¿´ïµ½ºÍwindowÒ»ÑùµÄЧ¹û¡£Õâ¸ö·½·¨Ò²ÊÊÓÃÓÚwindowϵͳ¡£
ÄÇÄãµÄÒâ˼¾ÍÊÇ˵
cmd Ö»ËãÊǹ¤¾ßµÄ×Ö·û½á
¶øNLS_LANGÊÇoracleµÄ¿Í»§¶Ë×Ö·û¼¯
ÊÇÕâÑù°É?
¿´Ò»Ï ÏÂÃæÕâ¶Î½âÊÍ:
1£©·þÎñÆ÷¶ËÊý¾Ý¿â×Ö·û¼¯Óë¿Í»§¶ËÓ¦ÓÃ×Ö·û¼¯Ïàͬ£¬Óë¿Í»§¶ËNLS_LANG²ÎÊýÉèÖò»Í¬Èç¹û¿Í»§¶ËNLS_LANG×Ö·û¼¯ÊÇÆäËüÁ½ÖÖ×Ö·û¼¯µÄ×Ó¼¯£¬×ª»»¹ý³Ì½«³öÏÖÂÒÂë¡£
½â¾ö·½·¨£º½«ÈýÖÖ×Ö·û¼¯ÉèÖóÉͬһ×Ö·û¼¯£¬»òNLS_LANG×Ö·û¼¯ÊÇÆäËüÁ½ÖÖ×Ö·û¼¯µÄ³¬¼¯
2 £©·þÎñÆ÷¶ËÊý¾Ý¿â×Ö·û¼¯Óë¿Í»§¶ËNLS_LANG²ÎÊýÉèÖÃÏàͬ£¬Óë¿Í»§¶ËÓ¦ÓÃ×Ö·û¼¯²»Í¬Èç¹û¿Í»§¶ËÓ¦ÓÃ×Ö·û¼¯ÊÇÆäËüÁ½ÖÖ×Ö·û¼¯µÄ³¬¼¯Ê±£¬×ª»»¹ý³Ì½«³öÏÖÂÒÂ룬µ«¶ÔÓÚµ¥×Ö½Ú±àÂë´æ´¢ÖÐÎÄÎÊÌ⣬¿É²Î¿´±¾ÎĵÚ5Õ½ڵķÖÎ
Ïà¹ØÎÊ´ð£º
ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ:
import java.sql.*;
public class as {
public static void main(String args[])throws Exception
{
Class.forName("oracle. ......
Oracle´æ´¢¹ý³ÌÈçÏÂ,ÓÃÓαêÊä³ö½á¹û:
procedure proc_xcxf_detail(v_sbh varchar2,
v_szpq varchar2,
&nbs ......
create or replace function GetWorkBeginTime()
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;
......
ÇëÎÊÒ»ÏÂ,C# winformÖÐͨ¹ýOleDbCommand,Ôõôµ÷ÓÃoracle·µ»ØÓαêÀàÐ͵ĺ¯Êý?¼±!!!
/// <summary>
/// Ö´Ðдø²ÎÊýµÄ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯
&nb ......
´ó¼ÒÍÆ¼öÒ»ÏÂ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´
Database Performance Tuning Guide and Reference
oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì ......