OracleÎÂÏ°ÓëÈëÃÅ

SQL Server¿ª·¢ÕßOracle¿ìËÙÈëÃÅ http://kb.cnblogs.com/a/853694 ¼òµ¥¸ÅÄîµÄ½éÉÜ 1. Á¬½ÓÊý¾Ý¿â
S:    use mydatabase
O:    connect username/password@DBAlias
       conn username/password@DBAlias 2. ÔÚOracleÖÐʹÓÃDual, DualÊÇOracleÒ»¸öÌØÓеÄÐéÄâ±í, OracleÖкܶàϵͳµÄ±äÁ¿ºÍº¯Êý¶¼¿ÉÒÔͨ¹ýDualÖлñµÃ
S:    select getdate();
O:    select sysdate from dual; 3. Select IntoºÍInsert Óï¾äµÄʹÓÃ, ÔÚSQL ServerÖеÄSelect IntoÓï¾äÔÚOracleÖÐÒ»°ãÊÇInsert into¡­select¡­, ÁíÍâ2¸öÊý¾Ý¿â¶¼Ö§³Ö±ê×¼µÄSQL, д·¨ÉÏÂÔÓÐÇø±ð
S:    select getdate() mycolumn into mytable;
       Insert mytable values(¡®more text¡¯);
O:    insert into mytable select getdate() mycolumn from dual
       insert into mytable (mycolumn) values(sysdate); 4. UpdateÓï¾ä
S:    update mytable set mycolumn=myothertable.mycolumn  
from mytable,myothertable 
where mytable.mycolumn like 'MY%' and myothertable.myothercolumn='some text';
O:    update mytable set mycolumn=
(select a.mycolumn from myothertable a
where myothertable.myothercolumn='some text')
where mytable.mycolumn like 'MY%'; 5. DeleteÓï¾ä
S:    delete mytable where mycolumn like 'some%';
O:    delete from mytable where mycolumn like 'some%'; 6. ʹÓÿª·¢¹ÜÀíµÄÈí¼þ
S:    isql
osql: for queries developed in SQL Analyzer
SQL Server Management Studio Express ͼÐλ¯¹ÜÀí¹¤¾ß
O:    sqlplus
       PL/SQL Developer ͼÐλ¯¿ª·¢¹ÜÀí¹¤¾ß
       TOAD                   ͼÐλ¯¿ª·¢¹ÜÀí¹¤¾ß
×¢: ¸öÈ˽¨Òé»ù±¾µÄ¼òµ¥µÄSelect