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

ÈçºÎ×öSQLServer·¢²¼ºÍOracle¶©ÔĵÄÎÊÌâ

oracle·¢²¼£¬sqlserver¶©ÔÄÎÒ×ö³É¹¦ÁË
µ«ÊÇsqlserver·¢²¼oracle¶©ÔÄÎÒʼÖÕʧ°Ü
Âé·³×ö¹ýµÄÅóÓÑÖ¸½ÌÒ»ÏÂ
ûµÃÈ˹Ø×¢Ñ½

ÒýÓÃ
ûµÃÈ˹Ø×¢Ñ½

²»ÊÇûµÃÈ˹Ø×¢.
ÊÇÁ½ÖÖ²»Í¬µÄ¿â,ÄãÕâô¸ãʵÔÚÌ«ÄÑÁË,°ï¶¥.

ÕâÒ²ÊÇÒ»¸öÑо¿ÐÔÎÊÌâ
ÒòΪÖÜΧûµÃÈË»á

ÎÒ¿´µ½csdnÉÏÓÐÈË×ö¹ýµÄ
µ«ÊÇÕÒ²»µ½ÄǸöÈ˵ÄÁªÏµ·½Ê½ÁË


ºÃÏñûÓйٷ½Ö§³Ö


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ