oracle»ù±¾²Ù×÷

describe  TABLE_NAME;   --ÃèÊö
----------------------------------------------------------------
create table as select XXXXXX
insert into TABLE_NAME (reac_1,reac_2.....) values(v1,v2)
insert into TABLE_NAME (select * from ..........)
update TABLE_NAME set reac_1=v1,................... where .....
delete from TABLE_NAME  where ...................
----------------------------------------------------------------
select [all|distinct top n[percent]] with ties  SELECT_LIST
[into[NEW_TABLE_NAME]]
[from {TABLE_NAME,....}][(OPTIMIZWE_HINTS)]
[where CLAUSE]
[group by CLAUSE]
[order by CLAUSE]
[compute CLAUSE]
[for browse]
--distinct ¼ìË÷ΨһµÄ±íÁÐÖµ
----------------------------------------------------------------
= != <> like and or between XXX and XXX in(XX,XX) union (ºÏ²¢²éѯ)
----------------------------------------------------------------
alter table TABLE_NAME add REAC_NAME  REAC_TYPE   --¸Ä±äÁÐ(Ìí¼ÓÁÐ)
EG: alter table scott.emp add name_my char(10) NULL;
alter table TABLE_NAME modify(name_my char(10))  --¸Ä±äÁ㤶È
alter table TABLE_NAME  DROP COLUMN name_my  --dropÁÐ
--------------------------
--º¯Êý-----------
---------------------------
asin() ·´ÕýÐþ  acos()·´ÓàÐþ atan()·´ÕýÇРatb2(,)·´ÕýÇÐ
sin()ÕýÐþ  cos()ÓàÐþ  tan()ÕýÇР cot()ÓàÇÐ
exp()Ö¸Êý  power(a,b)aµÄb´Î·½¸ù sort()ƽ·½¸ù square()ƽ·½
log()×ÔÈ»¶ÔÊý log10()¶ÔÊý abs()¾ø¶ÔÖµ 
ceiling(a)´óÓÚaµÄ×îСÕûÊý floor(a)СÓÚaµÄ×î´óÕûÊý 
rand()0-1µÄËæ»úÊý  pi()3.14159 sign(a) a<0,=0,>0ʱ,·µ»Ø-1,0,1
count()ºÏ¼Æ sum()ÇóºÍ max() min() 
----------------------------------------------------------------
ascii()ÇóascÖµ unicode()ÇóunicodeÖµ initcap()Ê××Öĸ±ä´óд
str(a,l,d)ת»¯Îª×Ö·û´®,aΪÊýÖµ,lΪ³¤,dΪ±£ÁôСÊýλÊý
len()Ç󳤠 left(a,l) right(a,l)