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

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

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

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

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

ÎÒÔÚ±¾»ú×°Á˸öoracle XE Client£¬ÇëÎʸÃÈçºÎÁ¬½Ó ÐéÄâ»úÉϵÄoracle

ÎÒÓà DRIVER={Microsoft ODBC for Oracle};UID=¡°system¡°;PWD=¡±5897577¡°;SERVER=¡±Êý¾Ý¿âÃû×Ö ;¡±

°ÑÎÒдµÄ³ÌÐò·Åµ½ÐéÄâ»úÉÏ¿ÉÒÔÁ¬½Ó£¬·Åµ½±¾»úÕâÑù¾Í²»ÄÜÁ¬½ÓÁË£¡

ÇëÎÊÈçºÎÐ޸쬻òÕ߯äËû·½·¨£¡

ÄÇÎÒÈí¼þÖÐÔõÃ´Ð´ÄØ£¿

ÂÛ̳ÈËÆøÔõôÕâôÉÙ


Ïà¹ØÎÊ´ð£º

vb Á¬½ÓORACLE ´òÓ¡

ÕâÊÇÎÒÔ­À´Á¬½ÓSQLµÄ´òÓ¡µÄ´úÂë
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;Data Source=mm;User ID=sa;Password=sa;Initial Catalog=lc-liuh2;Data Provider=SQLOLEDB.1"Ê ......

ÈçºÎ½«oracle±íת»»³ÉAccessÎı¾Îļþ

ÈçºÎ½«oracle±íת»»³ÉAccess±í»òÎı¾Îļþ
´ó¸ç¼±°¡¡£¡£
¿´ÄãÓÃʲô¹¤¾ß¡£ÓÃtoadÖ®ÀàµÄµ¼³ö¿ÉÒÔÑ¡Ôñµ¼³ö¸ñʽ¡£
ÓÃsqlplus¿ÉÒÔspool

·½·¨ºÜ¶à.
¿ÉÒÔÓÃpl/sql developer°Ñ±í±£´æÎªexcel,ÔÙ°Ñexcelµ¼Èëµ½ac ......

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

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

......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

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

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

ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ