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
Ïà¹ØÎĵµ£º
ÒòΪºÜÉÙÓõ½, ËùÒÔ¼¸ºõÍü¼ÇÁËÕ⼸¸öº¯Êý, ²»¹ýËüÃÇ»¹ÊǺÜÓÐÓõÄʹÓÃËüÃÇ¿ÉÒÔ´ó´ó¼ò»¯Ò»Ð©SQLÎĵÄÓï·¨, ÖÁÓÚЧÂÊÎÊÌâ, ÈçCCWËù˵ËüÃǺÍEXISTS, IN Ö®ÀàûÓÐʲô²î±ð, ¶øÇÒÒª¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
ÆäÖÐANYºÍSOMEÔÚÒâ˼ÉÏÊÇÏàͬµÄ, ¿ÉÒÔÏà»¥Ìæ´ú.
¾Ù¼¸¸öÀý×ÓÀ´ËµÃ÷ALLºÍANYµÄÓ÷¨
1. SELECT * from TABLEA WHERE FLD > AL ......
http://www.javaeye.com/topic/366991#
×÷Ϊһ¸ö¿ª·¢ÈËÔ±£¬¿ªÊ¼ÈÏÕæÏµÍ³Ñ§Ï°
Oracle SQLÒ²Ö»ÓÐÔÂÓ֮࣬ǰµÄ
SQLÖª
ʶ½ö½öÊÇÏîÄ¿ÀïÃæÓõ½Ê²Ã´¾ÍÈ¥¿´Ê²Ã´£¬¼òµ¥Ëµ¾ÍÊÇ
Read The Fxxking Guide¡£ÔÚϵͳѧϰ
Oracle
SQL֮ǰ£¬°³µÄÏë·¨¾ÍÊÇ“°´ÕÕÐèÇóÍê³É¹¦ÄÜ£¬Ê£ÏµĽ»¸ø
DBAÀ´´¦À픡£Õâ¸öÏë·¨´ÓÕûÌåÀ´¿´ÏÔ ......
¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄÒ»Ð©ÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......
Wait Problem Potential Fix Sequential Read Indicates many index reads—tune the code (especially joins) Scattered Read Indicates many full table scans—tune the code; cache small tables ......
¢Ù Ö»ÐèÔÚÎļþ TNSNames.ora ÖмÓÈëÒÔϽڵ㣬¼´¿É³É¹¦ÅäÖüàÌý
ORCL190 = //ºìÉ«²¿ÃÅΪÁ¬½Ó¼àÌýÃû×Ö
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.190)(PORT = 1521)) //ºìÉ«²¿ÃÅΪ·þÎñÆ÷ËùÔÚIPµØÖ· 1521Ϊ¶Ë¿ÚºÅ
(CONNECT_DATA ......