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

oracleËÀËøÔ­Òò·ÖÎö

ËÀËøµÄÔ­Òò
1¡£Ä£ÄâËÀËø
1¡£1¡£Ö÷±í
-- Create table
create table WDZ1
(
WDZ1ID NUMBER not null,
MEMO VARCHAR2(20)
)
;
alter table WDZ1
add constraint XXXXXX primary key (WDZ1ID);
1¡£2¡£´Ó±í£¨Ã»ÓÐÍ⽡µÄË÷Òý£©
-- Create table
create table WDZ2
(
WDZ2ID NUMBER not null,
WDZ1ID NUMBER,
MEMO VARCHAR2(20)
)
;
-- Create/Recreate primary, unique and foreign key constraints
alter table WDZ2
add constraint XXXXX primary key (WDZ2ID)
;
alter table WDZ2
add constraint XXX foreign key (WDZ1ID)
references WDZ1 (WDZ1ID);
1¡£3¡£²åÈëÊý¾Ý±íµ½×¡±í
begin
insert into wdz1 values (1,'aa');
insert into wdz1 values(2,'aa2');
insert into wdz1 values (3,'aa3');
insert into wdz2 values(10,3,'wdz3--1');
commit;
end;
1¡£4¡£ÔÚÒ»¸öÊý¾Ý¿âseeesionÀïÃæ²åÈëÊýµ½´Ó±í£¬µ«ÊDz»Ìá½»ÊÂÎñ
begin
update wdz2 set memo='update wdz2 momo'
where wdz2id=10;
insert into wdz2 values(20,2,'wdz2--1');
end;
¶Ô´Ó±í½øÐвåÈë/Ð޸ļǼ£¬Ê©¼ÓµÄËøÒ²¾ÍÊÇÐм¶Ëø
1¡£5¡£ÔÚÁíÍâÒ»¸öÊý¾Ý¿âseeesionÀïÃæÉ¾³ý Ö÷±íÊý¾Ý
delete from wdz1 where wdz1id=1
Õâʱºò ³ÌÐò»áËÀËø£¬³ý·Ç ÉÏÃæµÄ ¶Ô´Ó±íµÄ Êý¾Ý²Ù×÷Ìá½»ÊÂÎñ»òÕ߻عöÊÂÎñ¡£
2¡£¾ßÌåÔ­Òò·ÖÎö
Ò»¸öÊý¾Ý±íµÄÍâ¼üÖ÷ÒªÓÐ3ÖÖ·½Ê½À´Î¬»¤Ëü×Ô¼ººÍÖ÷±íÊý¾ÝµÄÒ»ÖÂÐÔ¡£
(1)delete cascade
Àý×ÓÈçÏ£º
alter table WDZ2
add constraint XXX foreign key (WDZ1ID)
references WDZ1 (WDZ1ID) on delete cascade;
(2)Set null
Àý×ÓÈçÏ£º
alter table WDZ2
add constraint XXX foreign key (WDZ1ID)
references WDZ1 (WDZ1ID) on delete set null;
(3)No action
×¢Ò⣬ÕâÊÇoracleÍâ¼üʹÓÃʱºòµÄĬÈÏÑ¡Ïî¡£
Àý×ÓÈçÏ£º
alter table WDZ2
add constraint XXX foreign key (WDZ1ID)
references WDZ1 (WDZ1ID);
ÒÔǰ³öÏÖËÀËøÖ÷ÒªÊÇÎÒÃÇÈÏΪ£¬ÔÚ 1¡£4¡£»á¶ÔÊý¾Ý±íwdz2½øÐÐÊ©¼ÓÐм¶Ëø£¬µ«ÊÇ´Ó±í(wdz2)µÄÍ⽡ÊÇNo action£¬É¾³ýÖ÷±í(wdz1)²»»áÈ¥·ÃÎÊ´Ó±í£¬¸ü²»»áÈ¥Ëø¶¨ wdz2±íµÄ¼Ç¼»òÕß¶ÔÕû¸öÊý¾Ý´Ó±í(wdz2)Ê©¼Ó±í¼¶Ëø¡£ÊÂʵÉÏ oralceµÄNo action Ñ¡ÏîµÄ×ÖÃæÒâ˼ÆÛÆ­ÁËÎÒÃÇ£¬oracleÔÚɾ³ýÖ÷±íµÄʱºò
»áȥѰÕÒËùÓÐÒÔÖ÷±íµÄÖ÷¼ü×÷ΪÍâ¼üµÄÊý¾Ý±í£¬È»ºó¿´È¥¿´´Ó±í
ÊÇ·ñÓиÃÍâ¼üµÄË÷Òý£¬Èç¹ûûÓÐÔò»á¶ÔÕû¸ö´Ó±íÊ©¼Ó±í¼¶Ëø£¬È»ºó
¶Ô´Ó±í½


Ïà¹ØÎĵµ£º

¹ØÓÚOracleµÄÐòÁУ¨Sequence£©Ê¹ÓÃ

OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......

OracleÐ¶ÔØ¸É¾»·½·¨

OracleÐ¶ÔØÐ¶²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
OracleÐ¶ÔØÐ¶²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
ÓÃoracleµÄÐ¶ÔØ³ÌÐò²¢²»ÄÜÍêÈ«Ð¶ÔØ¸É¾»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêÈ«Ð¶ÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ 
  &nbs ......

Íêȫɾ³ýOracle


ʵÏÖ·½·¨£º
     1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
     2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
  &nb ......

oracle ×Ö·û¼¯ÎÊÌâ

1.oracle×Ö·û¼¯ÎÊÌ⣺
Êý¾Ý¿â×Ö·û¼¯ÎªZHS16BGK£¬ºº×ÖÔÚÊý¾Ý¿â´æ·ÅµÄʱºòÕ¼ÓÃÁ½¸ö×Ö½Ú
Êý¾Ý¿â×Ö·û¼¯ÎªUTF8£¬ºº×ÖÔÚÊý¾Ý¿âÀï´æ·ÅµÄʱºòÕ¼ÓÃÈý¸ö×Ö½Ú
ÓÉÓÚ×Ö·û¼¯²»Í¬£¬µ¼ÖÂÏÖÔÚÊý¾Ý¿âIMPµÄʱºòÓÐЩ±íµÄ×ֶγ¤¶È²»¹»£¬³öÏÖORA-12899: value too large for columnµÄ´íÎó¡£
ͨ¹ýÐÞ¸Ä×Ö·û¼¯¿ÉÒÔ½â¾öÕâÖÖÎÊÌâ¡£
2.utf-8ºÍunico ......

Oracle´æ´¢¹ý³Ì

 Oracle´æ´¢¹ý³Ì¹¦ÄÜÇ¿´ó£¬ËûÖ÷ÒªµÄ×÷ÓÃÓÐÒÔϼ¸µã:
1.¿ÉÒÔÅúÁ¿Ö´ÐÐsqlÓï¾ä£¬ÌṩÄÚÖõÄÊÂÎñÖ§³Ö£¬Í¬Ê±Äܹ»Ìá¸ßÊý¾Ý¿â²Ù×÷µÄЧÂÊ¡£
2.¿Í»§¶Ë³ÌÐòÒÀ¾Ý´æ´¢¹ý³ÌÃûÀ´µ÷Óã¬Ìṩ³ÌÐòµÄ¿ÉÒÆÖ²ÐÔ¡£
3.Ìṩ¸´ÔÓµÄSQLÓï¾äÂß¼­Ö§³Ö¡£
Óï·¨½á¹¹°üÀ¨¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£
1£©²»´ø²ÎÊý£º
Create or replace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ