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
Ïà¹ØÎĵµ£º
1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ ......
declare
msg varchar(1000); --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg); --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg); --Êä³ö±äÁ¿
end; ......
oracle Âß¼±¸·ÝÃüÁîEXP/IMP²ÎÊý²Î¿¼ÊÖ²á
°ïÖúÃüÁexp help=y
Export: Release 10.2.0.1.0 - Production on Thu Jul 20 10:39:50 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed b ......
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇMTS
¡¡¡¡MTS = Multi-Threaded ServerMTSÊÇORACLE SERVERµÄÒ»¸ö¿ÉÑ¡µÄÅäÖÃÑ¡Ôñ£¬ÊÇÏà¶ÔDEDICATE·½Ê½¶øÑÔ£¬Ëü×î´óµÄÓŵãÊÇÔÚÒÔ²»ÓÃÔö¼ÓÎïÀí×ÊÔ´(ÄÚ´æ)µÄÇ°ÌáÏÂÖ§³Ö¸ü¶àµÄ²¢·¢µÄÁ¬½Ó¡£Joseph C.JohnsonÒԲ͹ݸø³öÒ»¸öMTSµÄÐÎÏóµÄ±ÈÓ÷
¡¡¡¡¼ÙÉèORACLEÊÇÒ»¼Ò²Í¹Ý£¬µ±Äã×ß½øÒ»¼Ò²Í¹ÝʱÄã¸Ð¾õ×îÊæ·þµÄ·þÎñ·½Ê½¾ÍÊ ......