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 PackageµÄ×÷ÓÃ
1¡¢¶¨ÒåÓë˵Ã÷
a. Ïà¹Ø¶ÔÏó£¨×Ô¶¨ÒåÀàÐÍ¡¢º¯Êý¡¢´æ´¢¹ý³ÌµÈ£©µÄ·â×°
b. ³ÌÐò°üµÄ¸÷²¿·Ö
- ³ÌÐò°ü¹æ¸ñ˵Ã÷
ÉùÃ÷×Ó³ÌÐò
- ³ÌÐò°üÖ÷Ìå
&n ......
oracle ´Ó10.2.0.2 µ½ 10.2.0.4 Éý¼¶
Ò»¡¢ÏÂÔØÉý¼¶°ü
ÏÂÔØµØÖ·£º
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
×¢Ò⣺²»ÒªÓÃflashgetÏÂÔØ£¬ÓÃѸÀ×ÏÂÔØ¡£Îļþ´óС1G¶à¡£
¶þ¡¢¹Ø±ÕÊý¾Ý¿â
ÒÔoracleÓû§Ô¶³ÌµÇ¼suseϵͳ:
1. sqlplus /nolog
SQL> connect /as sysdba
SQL> ......
lengthb(string)¼ÆËãstringËùÕ¼µÄ×Ö½Ú³¤¶È :·µ»Ø×Ö·û´®µÄ³¤¶È£¬µ¥Î»ÊÇ×Ö½Ú
length(string)¼ÆËãstringËùÕ¼µÄ×Ö·û³¤¶È :·µ»Ø×Ö·û´®µÄ³¤¶È£¬µ¥Î»ÊÇ×Ö·û
¶ÔÓÚµ¥×Ö½Ú×Ö·û,LENGTHBºÍLENGTHÊÇÒ»ÑùµÄ.
Èç¿ÉÒÔÓÃlength(‘string’)=lengthb(‘string’)ÅжÏ×Ö·û´®ÊÇ·ñº¬ÓÐÖÐÎÄ¡£
select lengt ......
http://hi.baidu.com/james_yulei/blog/item/7cc8c834063d6f3a0b55a920.html
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
2009-12-21 18:04
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
²Ù×÷ϵͳ£ºLinux
Êý¾Ý¿â£ºoracle9.2.0.4
1¡¢Êý¾Ý¿âÉèÖÃΪ¹éµµ·½Ê½
2¡¢Êý¾Ý¿âµÄ±¸·Ý½Å±¾
db_full_backup.sh £ºÊý¾Ý¿âÈ«±¸½Å±¾
db_l0_backup.sh £ºÊý¾Ý¿ ......
µÚÒ»²¿·Ö »ù±¾¸ÅÄî
Ò»¡¢ ......