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

OracleÎÊ´ðÌâ,´ð¶ÔÓзÖ,²»¶ÔÓйÄÀø·Ö

ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØϵʱµÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩

    1£©·þÎñÆ÷¶ËÊý¾Ý¿â×Ö·û¼¯Óë¿Í»§¶ËÓ¦ÓÃ×Ö·û¼¯Ïàͬ£¬Óë¿Í»§¶ËNLS_LANG²ÎÊýÉèÖò»Í¬Èç¹û¿Í»§¶ËNLS_LANG×Ö·û¼¯ÊÇÆäËüÁ½ÖÖ×Ö·û¼¯µÄ×Ó¼¯£¬×ª»»¹ý³Ì½«³öÏÖÂÒÂë¡£

    2 £©·þÎñÆ÷¶ËÊý¾Ý¿â×Ö·û¼¯Óë¿Í»§¶ËNLS_LANG²ÎÊýÉèÖÃÏàͬ£¬Óë¿Í»§¶ËÓ¦ÓÃ×Ö·û¼¯²»Í¬Èç¹û¿Í»§¶ËÓ¦ÓÃ×Ö·û¼¯ÊÇÆäËüÁ½ÖÖ×Ö·û¼¯µÄ³¬¼¯Ê±£¬×ª»»¹ý³Ì½«³öÏÖÂÒÂ룬µ«¶ÔÓÚµ¥×Ö½Ú±àÂë´æ´¢ÖÐÎÄÎÊÌâ.

  ÉÏÃæ2¸ö¶Î¶¨ÒåÕýȷô?Èç¹ûÕýÈ·Çë˵Ã÷Ô­Òò,²»ÕýÈ·Ò²Çë˵Ã÷Ô­Òò.
ÈËÄØ,ÊDz»ÊÇ·ÖÉÙÁË°¡

²»¶®£¬À´»ìµã¹ÄÀø·Ö

ÒýÓÃ
²»¶®£¬À´»ìµã¹ÄÀø·Ö

¹þ¹þ£¬±Ë´Ë±Ë´Ë£¬Ë³±ãµÈ×Å¿´ÕýÈ·´ð°¸

Ê×ÏÈ£¬²é¿´µ±Ç°µÄ·þÎñÆ÷µÄÊÇʲô±àÂëÒ²¾ÍÊÇ˵NLS_LANGÊÇʲô±àÂë¡£
SELECT * from v$nls_parameters;
Êý¾Ý¿â·þÎñÆ÷×Ö·û¼¯select * from nls_database_parameters props$
¿Í»§¶Ë×Ö·û¼¯»·¾³select * from nls_instance_parameters v$parameter
»á»°×Ö·û¼¯»·¾³ select * from nls_session_parameters  v$nls_parameters
Ò³ÃæÒ»°ã¶¼ÊÇutf-8
serverºÍmysql¡¢Oracle ĬÈÏΪunicode.
Èç¹û£¬¿Í»§¶ËÓë·þÎñÆ÷±àÂ벻ͳһµÄÇé¿öÏ»á³öÏÖÂÒÂëÁËÈýÖÖÔ­Òò¡£
1.¿Í»§¶Ë´«¹ýÀ´µÄÖÐÎÄÊý¾Ý½ÓÊÕµ½¾ÍÊÇÂÒÂë¡£
2.¿Í»§¶Ë´«¹ýÀ´µÄÖÐÎÄÊý¾Ý´æ·ÅÔÚÊý¾Ý¿â³öÏÖÂÒÂë¡£
3.´ÓÊý¾Ý¿â¶ÁÈ¡Êý¾Ý´æ´¢µÄÊý¾Ý³öÏÖÂÒÂë¡£

¿ÉÒÔ°ÑÊý¾Ý¿âÉèÖóÉͳһµÄ×Ö·û¼¯¡£
WindowsʹÓÃ
×¢²


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

oracle£¬mysql ºÍhibernateµÄÎÊÌâ¡£¡£¡£¡£¡£¡£¡£¼±

ÊÇÕâÑùµÄ£¬Ç°Ð©ÌìÎÒ·¢ÁËÒ»¸öoracle¸ÄmysqlµÄÌùô£¬ÏÖÔÚÓÖÓöµ½Á˵ãÎÊÌâ¡£¡£¡£Çë´ó¼Ò°ï°ïæ
oracleÀï±ßµÄlongÐÍ Ó³Éäµ½hibernateÀï±ßÊÇlongÐ͵Ġ £¬µ«Êǵ½ÁËmysqlÓ³ÉähibernateµÄʱºò¾ÍûÓÐlongÐÍÁË £¬¶¼ÊÇint ......

delphi È¡oracleϵͳ±ísys.aud$ÎÊÌâ

ÊÖÍ·ÓÐÒ»¸öÀϵIJúÆ·£¬delphi 6Á¬½Óoracle,È¡sys.aud$ϵͳ±íÀïÃæµÄÊý¾Ý

ÓÃAdoconnection+adodataset,

ÓÃsystemÓû§£¬Adoconnection Á¬½Ó³É¹¦£¬µ«Èç¹ûÔÚadodatasetÀïÃæд:

SELECT * from SYS.AUD ......

Á¬½ÓOracleÊý¾Ý¿â,À§ÈÅ

ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ:
import java.sql.*;
public class as {
public static void main(String args[])throws Exception
{
Class.forName("oracle. ......

Çë½Ì¹ØÓÚoracleµÄ×Ô¶¨Ò庯ÊýµÄÎÊÌâ

create or replace function GetWorkBeginTime()
  return date is
  myDate    date;
begin
  myDate := trunc(sysdate-1)+8/24;
  return myDate;
end;

......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ