Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

ÎÒÔÚLinuxÖÐÏÂÔصÄoracleÔõô°²×°£¿

Çë¸ßÊÖÖ¸½ÌÒ»¶þ  ··············  ·Ç³£¸Ðл£¡£¡£¡
ÐèÒªÏÂÔØlinux°æ°¡£¬»¹ÓÐÎļþ¸ñʽ

ÎÒÊÇÏÂÔصÄLinux°æµÄ


ÎûÎû£¬Ö»ÖªµÀÄǸö.rpm°üÀàËÆÓÚwindowsµÄ.exe¹þ£¬²»ÖªµÀÂ¥Ö÷ÏÂÔصÄÎļþÀïÃæÓÐûÓпÉÖ´ÐеÄÄØ£¿

isoµÄÒªmount
bin ......

Çë½Ìoracleµ¼³öµ½sql server2005

û¸É¹ýÕâÊ£¬Ò²²»ÖªµÀoracleÊý¾Ý¿âɶÑù£¬Çë½Ì´óϺÃǾßÌå²½ÖèÊÇʲô£¿ÐèҪעÒâЩʲô£¿
ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥?

Õæ¸öÊý¾Ý¿â

Õû¸öÊý¾Ý¿â£¬ÁíÍâÎÒÊÇ´Óһ̨װÓÐoracleµÄµçÄÔµ¼Èëµ½Áíһ̨װÓÐsql serverµÄµçÄÔÖС£¶àл£¡
ÒýÓÃ
ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥?



¸ÕgoogleÁËÏ£¬Ò²Ã»ÕÒµ½oracle µ¼ÈëSQL serverµÄ· ......

Çë½Ìoracleµ¼³öµ½sql server2005

û¸É¹ýÕâÊ£¬Ò²²»ÖªµÀoracleÊý¾Ý¿âɶÑù£¬Çë½Ì´óϺÃǾßÌå²½ÖèÊÇʲô£¿ÐèҪעÒâЩʲô£¿


ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
   
  1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
    ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅä ......

ORACLE sqlÓï¾äµÄÎÊÌâ

  ÏÖÔÚÓбíA£¨barcode varchar2£¬length number£©£¬B£¨barcode varchar2£¬serial number£©ÆäÖÐbarcode¹ØÁªA:BΪ1£ºn

ÓÐÈçÏÂsqlÓï¾ä
insert into a values('b1',10)
insert into a values('b2',20)
insert into a values('b3',30)
insert into b values('b1',1)
......

oracleÖеÄto_char£¬sql server 2005¶ÔÓ¦µÄ·½·¨ÊÇʲô

Ôõô°ÑÏÂÃæµÄ¸Ä³Ésql serverµÄ·½·¨£¿
to_char(img_comm_metadata.scene_centre_time,'yyyy-mm-dd hh24:mm:ss')>='1990-10-13 09:41:20'
SQL code:
datediff(ss,'1990-10-13 09:41:20',img_comm_metadata.scene_centre_time)>0

CONVERT(varchar(20),img_comm_metadata.scene_centre_time,120 ......

oracleÊý¾Ý¿âÁª½Ó³É¹¦£¬µ«²»ÄÜÖ´ÐÐSQLÓï¾ä

±¾È˸ÕѧϰORACLE£¬Çë¸ßÊÖÖ¸µãһϣ¬Íò·Ö¸Ðл£¡£¡£¡
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBUtil {
//oracleÁª½Ó
priva ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [296] [297] [298] [299] [300] [301] [302] 303 [304] [305]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ