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 = ‘Å®’)
);
Ïà¹ØÎĵµ£º
ÒÔÏÂÒÔ½ØͼÐÎʽ¼òÊö¹ØÓÚÔÚ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ÃüÁî½øÈëÈí¼þ£¨°ü£ ......
red hat linux Ï°²×° oracle 10g
racle¿¼×ÊÁÏ:
Oracle¹Ù·½ÍøÕ¾: http://download.oracle.com/docs/html/B10813_01/toc.htm
Ò»¡¢ÒÔrootÓû§µÇ¼, ½øÐÐÈçϲÙ×÷£º
1 ¼ì²éÓ²¼þÒªÇó
* Ö÷Òª°üÀ¨£º
********************************************************************
* ÄÚ´æ: & ......
×Ô¶¨Ò庯Êý
--×Ô¶¨Ò庯Êý
CREATE OR REPLACE FUNCTION fn_WFTemplateIDGet
(
TemplateCategoryID NUMBER,
OrganID NUMBER,
TemplateMode NUMBER
)
RETURN NUMBER
IS
......
latchÊÇÓÃÓÚ±£»¤Äڴ棨ϵͳȫ¾ÖÇø£¬SGA£©ÖеĹ²ÏíÄÚ´æ½á¹¹µÄ»¥³â»úÖÆ¡£Latch¾ÍÏñÊÇÄÚ´æÉϵÄËø£¬¿ÉÒÔÓÉÒ»¸ö½ø³Ì·Ç³£¿ìËٵؼ¤»îºÍÊÍ·Å£¬ÓÃÓÚ·ÀÖ¹¶ÔÒ»¸ö¹²ÏíÄÚ´æ½á¹¹½øÐв¢ÐзÃÎÊ¡£Èç¹ûlatch²»¿ÉÓã¬ÄÇô½«¼Ç¼latchÊÍ·Åʧ°Ü¡£¾ø´ó¶àÊýlatchÎÊÌⶼÓëûÓÐʹÓð󶨱äÁ¿£¨library-cache latch£¨¿â»º´ælatch£©£©¡¢ÖØ×öÈÕÖ¾Éú³ÉÎÊÌâ ......
Ò»¡¢²éѯij¸ö×Ö¶ÎÖظ´
select *
from User u
where u.user_name in (select u.user_name
&nbs ......