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

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


Ïà¹ØÎĵµ£º

Oracle³£ÓÃÓï¾ä

--ÈçºÎÓÃgrade±íµÄ×ÊÁÏÈ¥¸üÐÂusertable±íµÄ×ÊÁÏ£¨ÓйØÁªµÄ×Ö¶Îuserid£©
 update usertable u set u.grade =
 (select g.grade from grade g where g.userid = u.userid);
 
--ÈçºÎʹ²éѯ½á¹û×Ö¶ÎÉú³ÉÐòºÅ
select rownum, t.* from sm_t_pad_new t
--ÈçºÎ¿ìËÙ×öÒ»¸öºÍÔ­±íÒ»ÑùµÄ±¸·Ý±í
 create ......

ORACLE ×óÓÒÁ´½Ó

Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
     £¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......

ÓÅ»¯select count(*) (תoracleÅàѵÀÏʦµÄÎÄÕÂ)


select count(*) from t1;
Õâ¾ä»°±È½Ï¼òµ¥£¬µ«ºÜÓÐÐþ»ú£¡¶ÔÕâ¾ä»°ÔËÐеÄÀí½â£¬·´Ó³ÁËÄã¶ÔÊý¾Ý¿âµÄÀí½âÉî¶È£¡
½¨Á¢ÊµÑéµÄ´ó±íËût1
SQL> conn scott/tiger
ÒÑÁ¬½Ó¡£
SQL> drop table t1 purge;
±íÒÑɾ³ý¡£
SQL> create table t1 as select * from emp where 0=9;
±íÒÑ´´½¨¡£
SQL> insert into t1 sele ......

oracle¾­ÑéÖ®ANY,SOME,ALLÇø±ð


ÒòΪºÜÉÙÓõ½, ËùÒÔ¼¸ºõÍü¼ÇÁËÕ⼸¸öº¯Êý, ²»¹ýËüÃÇ»¹ÊǺÜÓÐÓõÄʹÓÃËüÃÇ¿ÉÒÔ´ó´ó¼ò»¯Ò»Ð©SQLÎĵÄÓï·¨, ÖÁÓÚЧÂÊÎÊÌâ, ÈçCCWËù˵ËüÃǺÍEXISTS, IN Ö®ÀàûÓÐʲô²î±ð, ¶øÇÒÒª¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
ÆäÖÐANYºÍSOMEÔÚÒâ˼ÉÏÊÇÏàͬµÄ, ¿ÉÒÔÏà»¥Ìæ´ú.
¾Ù¼¸¸öÀý×ÓÀ´ËµÃ÷ALLºÍANYµÄÓ÷¨
1. SELECT * from TABLEA WHERE FLD > AL ......

ORACLEµÄJOB´´½¨

ORACLEµÄJOB´´½¨£¬¿ÉϧµÄÊDz»ÄܸÄÃû£¬Ö»ÄÜÊÇÊý×ÖµÄÃû×Ö¡£
DECLARE X NUMBER;
BEGIN
  SYS.DBMS_JOB.SUBMIT
  ( job       => X
   ,what      => 'compile_invalid_object;'
   ,next_date => to_date('20-04-2010 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ