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

oracle cartridge¿ª·¢

ÄÄλÐÖµÜÓÐoracle cartradge¿ª·¢×ÊÁÏ£¬Äܲ»Äܹ²Ïíһϣ¿Ð»Ð»£¡

ûÓÐÌý˵¹ý£¬OracleÌ«ÅÓ´óÁË

ÎÒÒ²ÊǸսӴ¥£¬²»Çå³þÔõô×ö£¬Ö»ÖªµÀÕâ¸ö¼¼ÊõÊÇÓÃÀ´¿ª·¢Öмä¼þµÄ



End_rbody_60301247//-->
¸Ã»Ø¸´ÓÚ2009-10-11 09:05:28±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP








Ïà¹ØÎÊ´ð£º

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

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

......

oracle´æÈ¡Ð¡ÓÚ1µÄСÊý£¬ÎªÊ²Ã´ÊÇûÓÐÁã

ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É  .5  µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾ­ÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿

ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......

Çë½ÌDRIVER={Microsoft ODBC for Oracle} Á¬½ÓÎÊÌ⣡

ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡

ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100

ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬

ÎÒÔÚ±¾»ú×°Á˸öoracle XE Cl ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

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

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ