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
Ïà¹ØÎĵµ£º
--ÈçºÎÓÃ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 ......
Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
£¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......
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 ......
ÒòΪºÜÉÙÓõ½, ËùÒÔ¼¸ºõÍü¼ÇÁËÕ⼸¸öº¯Êý, ²»¹ýËüÃÇ»¹ÊǺÜÓÐÓõÄʹÓÃËüÃÇ¿ÉÒÔ´ó´ó¼ò»¯Ò»Ð©SQLÎĵÄÓï·¨, ÖÁÓÚЧÂÊÎÊÌâ, ÈçCCWËù˵ËüÃǺÍEXISTS, IN Ö®ÀàûÓÐʲô²î±ð, ¶øÇÒÒª¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
ÆäÖÐANYºÍSOMEÔÚÒâ˼ÉÏÊÇÏàͬµÄ, ¿ÉÒÔÏà»¥Ìæ´ú.
¾Ù¼¸¸öÀý×ÓÀ´ËµÃ÷ALLºÍANYµÄÓ÷¨
1. SELECT * from TABLEA WHERE FLD > AL ......
ORACLEµÄJOB´´½¨£¬¿ÉϧµÄÊDz»ÄܸÄÃû£¬Ö»ÄÜÊÇÊý×ÖµÄÃû×Ö¡£
DECLARE X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'compile_invalid_object;'
,next_date => to_date('20-04-2010 ......