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

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)


Ïà¹ØÎĵµ£º

Oracle 10.2.0.3 Patch°²×°

      Oracle 10.2.0.1µÄPatchµµÖð½¥ÐγÉÁ˼Ò×åÌåϵÁË,ÏÖÔÚÈôó¼ÒÀ´ÈÏʶһÏÂÕâ¸öÌåϵ°É!µ½Ä¿Ç°Ëù·¢²¼µÄÖ÷ÒªµÄPatchÓÐ10.2.0.2,10.2.0.3,10.2.0.4,10.2.0.4.1,10.2.0.4.2,10.2.0.4.3,10.2.0.5.
      ֮ǰÔÚ32λºÍ64λLinuxϰ²×°Á˽ÏΪÎȶ¨µÄOracle 10G for Linux x86º ......

Oracle TRANSLATEÓ÷¨

Óï·¨£ºTRANSLATE(expr,from,to)
expr: ´ú±íÒ»´®×Ö·û£¬from Óë to ÊÇ´Ó×óµ½ÓÒÒ»Ò»¶ÔÓ¦µÄ¹ØÏµ£¬Èç¹û²»ÄܶÔÓ¦£¬ÔòÊÓΪ¿ÕÖµ¡£
¾ÙÀý£º
select translate('abcbbaadef','ba','#@') from dual¡¡£¨b½«±»££Ìæ´ú£¬a½«±»£ÀÌæ´ú£©
select translate('abcbbaadef','bad','#@') from dual¡¡£¨b½«±»££Ìæ´ú£¬a½«±»£ÀÌæ´ú£¬d¶ÔÓ¦µÄÖµÊÇ¿Õ ......

Oracle·ÖÎöº¯Êý²Î¿¼

Ê×ÏȸÐлÎÄÕµÄ×÷Õß,ÎÒתÀ´´ó¼Ò¹²Ïí
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊǶÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÀý×ÓÖÐʹÓõıíÀ´×ÔOracle×Ô´øµÄHRÓû§ÏÂµÄ±í£¬Èç¹ûûÓа²×°¸ÃÓû§£¬¿ÉÒÔÔÚSYSÓû§ÏÂÔËÐÐ$ORACLE_HOME/demo/schema/human_re ......

help!ORACLE RMAN»Ö¸´ÎÊÌâORA 01152 ORA 01110

Òì»ú»Ö¸´¹ý³Ì£º
ÔÚrman>run
{
allocate channel ch00 type 'sbt_tape' parms="ENV=(NB_ORA_CLIENT=zjddms1)";
set newname for datafile 1 to '/oradata/zjdms/1.dbf';
......
set newname for datafile 23 to '/oradata/test/23.dbf';
set newname for datafile 24 to '/oradata/test/24.dbf';
restore databas ......

oracle pl/sql ±à³Ì

                                              µÚÒ»²¿·Ö  »ù±¾¸ÅÄî
Ò»¡¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ