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

Oracle³£ÓÃSQLÓï¾ä(PL/SQL developer¹¤¾ßϵÄ)

 ½¨±í
create table users(
id number(4) primary key,
username varchar2(10),
password varchar2(10)
)
²éѯ±í²¢½âËø±í(¼´¿ÉÒÔµã»÷ÊäÈë¿òÏÂÃæµÄ"Ëø"ͼ±ê¹¤¾ß, ¼´"Edit data")
select * from users for update
ɾ³ý±íÖжàÓàµÄÁÐ
alter table mobilephone drop column mobiletype
תÔØ
-----------------------------------------------------------------------------------------------
oracle²Ù×÷Óï¾ä£º
1.´´½¨±í
create table ±íÃû(
 ÁÐÃû1 ÀàÐÍ£¬
 ÁÐÃû2 ÀàÐÍ
);
2.ÐÞ¸ÄÀàÊôÐÔ
alter table ±íÃû modify(ÁÐÃû ÀàÐÍ);
3.Ìí¼ÓÁÐ
alter table ±íÃû add(ÁÐÃû ÀàÐÍ);
4.Ìí¼ÓÖ÷¼üÔ¼ÊøºÍ·Ç¿ÕÔ¼Êø
alter table ±íÃû add constraint pk_±íÃû primary key(ÁÐÃû);
alter table ±íÃû modify(ÁÐÃû not null);
5.ɾ³ýÖ÷¼üÔ¼Êø
alter table ±íÃû drop primary key;
alter table ±íÃû drop constraint pk_±íÃû;
6.ʧЧԼÊø
alter table ±íÃû disable primary key;
alter table ±íÃû disable constraint pk_±íÃû;
7.ÓÐЧԼÊø
alter table ±íÃû enable primary key;
alter table ±íÃû enable constraint pk_±íÃû;
8.ɾ³ýÁÐ
alter table ±íÃû drop column ÁÐÃû;
9.ÉèÖÃijÁв»¿ÉÓã¬È»ºóɾ³ý
alter table ±íÃû set unused(ÁÐÃû);
alter table ±íÃû drop unused columns;
10.Ð޸ıíÃû
rename ±íÃû1 to ±íÃû2
alter ±íÃû1 rename to ±íÃû2;
11.½Ø¶Ï±í
truncate table ±íÃû;
12.½Ø¶Ï±í±£ÁôÐпռä
truncate table ±íÃû resue storage;
13.²é¿´±í½á¹¹
desc table ±íÃû;
14.ɾ³ý±í
drop table ±íÃû;
15.²åÈë¼Ç¼
Àý£ºinsert into ±íÃû values(ÄÚÈÝ1,ÄÚÈÝ2,ÄÚÈÝ3,ÄÚÈÝ4);
16.´ø²ÎÊý¶Ô»°·½Ê½²åÈëÐÐ
Àý:insert into ±íÃû values(&ÁÐÃû1,&ÁÐÃû2);
  insert into ±íÃû values(ÄÚÈÝ1,ÄÚÈÝ2);
17.²åÈëij¼¸ÁмǼ
insert into ±íÃû(ÁÐÃû1,ÁÐÃû2) values(ÄÚÈÝ1,ÄÚÈÝ2);
18.ΪÁвåÈë¿ÕÖµ£¨ÆäÁв»ÄÜΪnot null£©
insert into ±íÃû values(ÄÚÈÝ1,null,null);
19.´´½¨±í£¨°üÀ¨Ö÷¼ü¼°Íâ¼üÉèÖã©·½·¨Ò»
create table ±íÃû(
  ÁÐÃû1 ÀàÐÍ
  constraint pk_±íÃû primary key,
  ÁÐÃû2 ÀàÐÍ not null,
  ÁÐÃû3 ÀàÐÍ 
  constraint fk_±íÃû reference ±íÃû(ÁÐÃû),
  ÁÐÃû3 ÀàÐÍ
  constraint


Ïà¹ØÎĵµ£º

SQLÓï¾äЧÂÊÎÊÌâµÄ¼¸µã×ܽá

 1. SQLÓÅ»¯µÄÔ­ÔòÊÇ£º
  ½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£  
  µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺  
  ¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ  
  ¼ì²é×Ó²éѯ   ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ ......

½âÎöoracleµÄrownum

¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
¾ÙÀý˵Ã÷£º
ÀýÈç±í£ºstudent(ѧÉú)±í£¬±í½á¹¹Îª£º
ID¡¡¡¡¡¡    char(6)¡¡¡¡¡¡¡¡¡¡ --ѧºÅ
name¡¡¡¡¡¡¡¡VA ......

oracle Ë÷Òý

2009-07-16 10:59
Ë÷Òý´´½¨²ßÂÔ
1.µ¼ÈëÊý¾ÝºóÔÙ´´½¨Ë÷Òý
2.²»ÐèҪΪºÜСµÄ±í´´½¨Ë÷Òý
3.¶ÔÓÚÈ¡Öµ·¶Î§ºÜСµÄ×ֶΣ¨±ÈÈçÐÔ±ð×ֶΣ©Ó¦µ±½¨Á¢Î»Í¼Ë÷Òý
4.ÏÞÖƱíÖеÄË÷ÒýµÄÊýÄ¿
5.ΪË÷ÒýÉèÖúÏÊʵÄPCTFREEÖµ
6.´æ´¢Ë÷ÒýµÄ±í¿Õ¼ä×îºÃµ¥¶ÀÉ趨
´´½¨²»Î¨Ò»Ë÷Òý
create index emp_ename on employees(ename)
table ......

Oracle MTS

¡¡¡¡Ò»¡¢Ê²Ã´ÊÇMTS
¡¡¡¡MTS = Multi-Threaded ServerMTSÊÇORACLE SERVERµÄÒ»¸ö¿ÉÑ¡µÄÅäÖÃÑ¡Ôñ£¬ÊÇÏà¶ÔDEDICATE·½Ê½¶øÑÔ£¬Ëü×î´óµÄÓŵãÊÇÔÚÒÔ²»ÓÃÔö¼ÓÎïÀí×ÊÔ´(ÄÚ´æ)µÄÇ°ÌáÏÂÖ§³Ö¸ü¶àµÄ²¢·¢µÄÁ¬½Ó¡£Joseph C.JohnsonÒԲ͹ݸø³öÒ»¸öMTSµÄÐÎÏóµÄ±ÈÓ÷
¡¡¡¡¼ÙÉèORACLEÊÇÒ»¼Ò²Í¹Ý£¬µ±Äã×ß½øÒ»¼Ò²Í¹ÝʱÄã¸Ð¾õ×îÊæ·þµÄ·þÎñ·½Ê½¾ÍÊ ......

oracle 10.2g ÔÚCentOS 5.1µÄ°²×°¹ý³Ì

µÚÒ»²½¡¢¼ì²é²Ù×÷ϵͳ»·¾³
rpm -q gcc make binutils openmotif glibc setarch compat-db compat-gcc-34 openmotif compat-gcc-34-c++ compat-libstdc++-33
Èç¹û¼ì²âµ½Äĸö°üûÓÐ×°£¬Ôò·Ö±ðÔÚISO¾µÏñÎļþÖÐÕÒµ½½øÐа²×°
¹ÒÔØ6ÕÅ»ò7ÕÅISOÎļþ£¬
±ÈÈç˵£ºrpm -ivh /mnt/iso/3/CentOS/openmotif*
Ö»ÒªÊÇûÓÐ×°µÄ¶¼Òª½øÐа ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ