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

oracle ѧϰ±Ê¼Ç1

½¨Á¢ÁÙʱ±í½á¹¹
create global temporary table myemp as select * from emp;
Ð޸ıí½á¹¹
alter table dept modify (Dname char(20));
alter table dept add (headcount number(3));
¸´ÖÆÒ»¸ö±í
create table emp3 as select * from emp;
²ÎÕÕij¸öÒÑ´æÔÚµÄ±í½¨Á¢Ò»¸ö±í½á¹¹£¬²»ÐèÒªÊý¾Ý
create table emp4 as select * from emp where rownum<1;
ÐÞ¸ÄÒÑ´æÔÚ±í´æ´¢²ÎÊý
alter table emp2 storage(next 256K pctincrease 0);
ɾ³ý±íÖеÄÁУº
alter table emp drop column comm;
ÖØж¨Î»ºÍ×éÖ¯±í
alter table emp move tablespace users;
½«±í±êʶΪ²»¿ÉÓÃ
alter table emp set unused column xyz;
ʹÓÃcheck×÷ÏÞÖÆÔ¼Êø£¬check¿ÉÒÔʵÏÖ¶ÔÊý¾ÝµÄ×Ô¶¯¼ì²é
create table worker
(  empno number(4) primary key,
   name  varchar2(10),
   age   number(2) check (age between 18 and 65),
   sex  char(2)  check (sex ='ÄÐ' or sex = ‘Å®’)
);


Ïà¹ØÎĵµ£º

OracleÏÞÖÆIP·ÃÎÊÉèÖÃ

Ò»¡¢$vi $ORACLE_HOME/network/admin/sqlnet.ora
Èç¹û¸Ãsqlnet.oraÎļþ²»´æÔÚ£¬¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½Éú³É
1£©¿ÉÒÔ¿½±´$ORACLE_HOME/network/admin/samples/sqlnet.oraµ½$ORACLE_HOME/network/admin/Ŀ¼ÏÂʹÓÃ
2£©Ê¹ÓÃnetca¹¤¾ß½øÐÐÅäÖã¬NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
 
¶þ¡¢ÉèÖûòÐ޸IJÎÊý£¨Èç¹û²ÎÊ ......

OracleÁÙʱ±í

Temporary TablesÁÙʱ±í
1¼ò½é
   ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
   »òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
   µ«ÊÇÁÙʱ± ......

Oracle´æ´¢¹ý³Ì

ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô­×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼--------------------
......

Oracle DECODE

Óï·¨£º
DECODE(expr, search, result [, search, result ]... [, default ] )
Ó¦Óãº
DECODEº¯Êý½«Ã¿Ò»¸öexprºÍsearchµÄÖµ×ö±È½Ï¡£Èç¹ûexprµÄÖµÓësearchµÄÖµÏàµÈ£¬OracleÊý¾Ý¿â¾Í»á·µ»ØÏàÓ¦µÄresult¡£Èç¹ûÕÒ²»µ½Æ¥ÅäµÄÖµ£¬Oracle·µ»Ødefault¡£Èç¹ûûÓÐdefault£¬Oracle·µ»ØnullÖµ¡£²ÎÊý¿ÉÒÔÊÇÈÎÒâÊýÖµÀàÐÍ£¨NUMBER£¬BINAR ......

oracle hintÖÐordered ºÍleadingÔ­ÀíºÜºÃµÄÌû×Ó

ÎÊÌ⣺Çë½ÌHINTд·¨
ÎÒÓÐÒ»¸öSQLÌí¼ÓÈçÏÂhint,Ä¿µÄÊÇÖ¸¶¨hash_join·½Ê½¡£
select /*+ordered use_hash(a,b,c,d) */ *
from a,b,c,d
Where ...
ÆäÖÐ,
      aÖ»ÓëbÓйØÁª¹Øϵ£¬bÖ»ÓëcÓйØÁª¹Øϵ£¬bÖ»ÓëcÓйØÁª¹Øϵ,cÖ»ÓëdÓйØÁª¹Øϵ£¬
    ÊýÁ¿¼¶£ºa:1000Ìõ,  b:100 ÍòÌõ£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ