Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÊÂÎñµÄ×ܽá

¹ØÓÚOracleÊÂÎñµÄ×ܽá
1.ʲôÊÇÊÂÎñ£¬ÊÂÎñµÄÌØÐÔÊÇʲô£¿
ÊÂÎñµÄÈÎÎñ±ãÊÇʹÊý¾Ý¿â´ÓÒ»ÖÖ״̬±ä»»³ÉΪÁíÒ»ÖÖ״̬£¬ÕⲻͬÓÚÎļþϵͳ£¬ËüÊÇÊý¾Ý¿âËùÌØÓõġ£ËüµÄÌØÐÔÓÐËĸö£ºTOM×ܽáΪACID¼´
Ô­×ÓÐÔatomicity:Óï¾ä¼¶Ô­×ÓÐÔ£¬¹ý³Ì¼¶Ô­×ÓÐÔ£¬ÊÂÎñ¼¶Ô­×ÓÐÔ
Ò»ÖÂÐÔconsistency:״̬һÖ£¬Í¬Ò»ÊÂÎñÖв»»áÓÐÁ½ÖÖ״̬
¸ôÀëÐÔiso ......

ÂíÍõÒ¯Ô­´´ Oracle Installation for AIX 5L

ÒÔÏÂÒÔ½ØÍ¼ÐÎʽ¼òÊö¹ØÓÚÔÚIBMСÐÍ»úÉϰ²×°µ¥»ú°æOracleÊý¾Ý¿âµÄ¹ý³Ì¡£ÒÔ¹©´ó¼Ò²Î¿¼£¬ÒÔ±ã¶ÔÓÚIBMСÐÍ»ú&AIX&Oracle½øÐгõ²½µÄÁ˽⡣ Machine£ºIBM POWER 520 OS&Version£ºAIX_5300-07 Oracle Version:10.2.0.1 ÒÔÏÂÊÇÏêϸ½ØÍ¼£º 1_OS_Check&Filesets_Check 2_ÀûÓÃsmitty installpÃüÁî½øÈëÈí¼þ£¨°ü£ ......

OracleÁÙʱ±í

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

Oracle LATCHѧϰ

latchÊÇÓÃÓÚ±£»¤Äڴ棨ϵͳȫ¾ÖÇø£¬SGA£©ÖеĹ²ÏíÄÚ´æ½á¹¹µÄ»¥³â»úÖÆ¡£Latch¾ÍÏñÊÇÄÚ´æÉϵÄËø£¬¿ÉÒÔÓÉÒ»¸ö½ø³Ì·Ç³£¿ìËٵؼ¤»îºÍÊÍ·Å£¬ÓÃÓÚ·ÀÖ¹¶ÔÒ»¸ö¹²ÏíÄÚ´æ½á¹¹½øÐв¢ÐзÃÎÊ¡£Èç¹ûlatch²»¿ÉÓã¬ÄÇô½«¼Ç¼latchÊÍ·Åʧ°Ü¡£¾ø´ó¶àÊýlatchÎÊÌâ¶¼ÓëûÓÐʹÓð󶨱äÁ¿£¨library-cache latch£¨¿â»º´ælatch£©£©¡¢ÖØ×öÈÕÖ¾Éú³ÉÎÊÌâ ......

ÓÃoracle¶ÁÈ¡±¾µØÎļþ

ÓÃoracle¶ÁÈ¡±¾µØÎļþ
Ê×ÏÈÒªÔÚoracleÖд´½¨Îļþ¼Ð£¬È»ºó¸³ÓèÏàÓ¦µÄ¶ÁдȨÏÞ£¬È»ºóÊý¾Ý¿â²ÅÄܶÁȡϵͳÖеÄÎļþ
--´´½¨Îļþ¼Ð ²¢¸³ÓèȨÏÞ¸øÓû§
create or replace directory DIRNAME as 'D:\skybook2';
grant read,write on directory DIRNAME as to USERNAME;
GRANT EXECUTE ON utl_file TO USERNAME;
´´½¨³É¹¦¿ÉÒÔ² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ