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

Oracle»ù´¡Ñ§Ï°±Ê¼Ç

1.sqlplus-----¿ªÆô·þÎñ
2.ÊäÈëÓû§ÃûºÍÃÜÂ루ĬÈÏ3¸öÓû§,×¢Ò⣬ÃÜÂëÊÇ¿ÉÒÔÐ޸ĵģºsystem/manager;scott/tiger;sys/change_on_install£©£¬Á¬½ÓÊý¿â¡£
3.´´½¨±í¿Õ¼ä£º
 create tablespace ±í¿Õ¼äÂß¼­Ãû datafile '±í¿Õ¼äÎļþµÄÎïÀíÂß¼­'
 size Îļþ´óС£¨È磺10m£© autoextend ÊÇ·ñ×Ô¶¯Ôö³¤Îļþ´óС£¨on/off£©;
4.´´½¨Óû§£ºcreate user Óû§Ãû identified by ÃÜÂ룻
5.Óû§ÊÚȨ£ºgrant connect to Óû§Ãû  --------±íʾÊÚÓèÓû§Á¬½ÓµÄȨÏÞ
     grant dba to Óû§Ãû  ------±íʾÊÚÓè¹ÜÀíÔ±µÄȨÏÞ
     grant resource to Óû§Ãû -----±íʾ´´½¨Ò»¸öȨÏÞ¶ÔÏó
     --Á¬½Ó
     conn admin/admin;
     --Á¬½Óµ±Ç°Óû§
     conn yangjian/yangjian;
     --ÐÞ¸ÄÓû§ÃÜÂë
     alter user system identified by system;
     --ɾ³ýÓû§(cascadeɾ³ýģʽ¶ÔÏó)
     drop user admin cascade;
6.exit  -----Í˳öÁ¬½Ó
7.´´½¨±í£º
 create table ±íÃ÷
 £¨
  sid varchar2(20),    --varchar2±íʾ¶¯Ì¬µÄ×Ö·ûÀàÐÍ
  sage int   ----Êý×ÖÀàÐÍ
 £©;
 --ɾ³ý±í¿Õ¼ä
 Drop tablespace spac
 --Ð޸ıí
 --1.Ϊָ¶¨µÄ±íÌí¼ÓÒ»ÁÐ
 alter table student add(score varchar2(3))
 --2.ÐÞ¸ÄÖ¸¶¨ÁÐ
 alter table student modify(score number(3,1))
 --3.ɾ³ýÖ¸¶¨µÄÁÐ
 alter table student drop column score
 --4.²é¿´Ö¸¶¨±íµÄ½á¹¹
 desc student
 --ɾ³ý±í
 --1.ֻɾ³ý±íÖеÄËùÓÐÊý¾Ý£¬±£Áô±íµÄ½á¹¹
 truncate table student
 delete student;
 --2.ɾ³ýÕû¸ö±í£¬°üÀ¨±íµÄÕû¸ö½á¹¹
 drop table student
8.show user   ------ÏÔʾµ±Ç°µÇ½Óû§Ãû
9.´´½¨Ò»¸öÐòÁУº
 create sequence  ÐòÁÐÃû start with 1 increment by 2 minvalue 1 maxvalue 2000
 cycle/uncycle;     -----±íʾ¸ÃÐòÁдÓ1¿ªÊ¼£¬×ÔÔö2£¬×îСֵ1£¬×î´óÖµ2000£¬cycle±íʾµ½´ï×î´óÖµºó    


Ïà¹ØÎĵµ£º

Oracle Decodeº¯ÊýʹÓü¼ÇÉ


decodeº¯Êý
Óï·¨£º
decode(expr,search,result[,search,result]..[,search,result][,default])
½âÊÍ£º
±È½ÏexprÓëÿ¸ösearchµÄÖµ£¬Èç¹ûexprµÈÓÚij¸ösearch£¬Ôò·µ»ØÏàÓ¦µÄresult£»Èç¹ûûÓÐÆ¥ÅäµÄÖµ£¬Ôò·µ»ØdefaultÖµ£»Èç¹ûûÓÐÖ¸¶¨defaultÖµ£¬Ôò·µ»Ønull
×¢Ò⣺
±È½Ïǰ£¬Oracle×Ô¶¯½«exprµÄÊý¾ÝÀàÐÍת»»³ÉµÚÒ»¸ösear ......

OracleµçÁ¦ÐÐÒµ½â¾ö·½°¸ ¸¶Ê×ê¿

ÖйúµçÁ¦ÐÐҵĿǰÕýÔÚ¾­Àúמ޴óµÄ±ä»¯£º´Ó¹ú¼Ò°ìµçµ½ÆóÒµ°ìµç£¬ÐγÉÁ˶à¼Ò¾ºÕù°ìµçµÄ¸ñ¾Ö£»³§Íø·Ö¿ª¡¢¾º¼ÛÉÏÍø£¬´Ó¼Æ»®µ½Êг¡×ª¹ì£¬ÒýÈë¶àÖÖ¾­¼Ã³É·Ö£»´ÓµØÓòÐÔ·ÖÉ¢¹©µçÏò´óµçÍø·¢Õ¹£»´ÓÕþÆó²»·Öµ½ÕþÆó·Ö¿ª¡£ÕâЩ±ä»¯£¬Ê¹ÖйúµÄµçÁ¦ÐÐÒµ¾­ÊÜ×ÅǰËùδÓеÄѹÁ¦¡£
    Ò»·½Ã棬2003Äê¹úÄڵķ¢µçÆóÒµÖØÐ¸Ä×é£ ......

Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü

Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü
ÉÏһƪ / ÏÂһƪ  2008-09-04 11:25:01
²é¿´( 1991 ) / ÆÀÂÛ( 0 ) / ÆÀ·Ö( 0 / 0 )
ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_ ......

Oracle 10G DataGuard

http://hi.baidu.com/firefly5002/blog/item/5b5719fcb5bd3e1d08244d11.html
Oracle 10G DataGuard
server A: 10.85.10.44 SID=mesdb
target server B: 10.85.10.43
oracle version:10.2.0.1
OS platform : windows 2003
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£
ALTER DATABASE ......

BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©

BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©
CREATE OR REPLACE FUNCTION BlobToClob(blob_in IN BLOB) RETURN CLOB AS
  v_clob    CLOB;
  v_varchar VARCHAR2(32767);
  v_start  PLS_INTEGER := 1;
  v_buffer  PLS_INTEGER := 32767;
BEGIN
  DBMS_LOB.CRE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ