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 job ¼ä¸ôʱ¼ä trunc
¼ÙÉèÄãµÄ´æ´¢¹ý³ÌÃûΪPROC_RAIN_JM
ÔÙдһ¸ö´æ´¢¹ý³ÌÃûΪPROC_JOB_RAIN_JM
ÄÚÈÝÊÇ£º
Create Or Replace Procedure PROC_JOB_RAIN_JM Is li_jobno Number; &nb ......
×÷ΪoracleµÄÏúÊÛÕæÐÄÕæÒâµÄÔÒâÓë´ó¼Ò·ÖÏíoracleµÄÒ»ÇУ¬ÎÒÕâ±ß²»ÊÇÇþµÀ£¬ÊÇoracle×ÊÉî×Ü´úÀí£¨ÖйúÈí¼þÓë¼¼Êõ·þÎñ¹É·ÝÓÐÏÞ¹«Ë¾£©£¬Ï£Íû´ó¼ÒÓйºÂòoracleÒâÔ¸µÄʱºò¼ÇµÃÎÒ£¨ÕÔÌìÊæ 15010529916£©£¬ÎһᾡÎÒËùÄܵİïÖú´ó¼Ò¡£
×î½üÓкܶàÈËÎÊÎÒoracleµÄ¹ºÂò·½Ê½£ºÔÚÕâÀïÎÒÏë²ûÊöµÄÊÇÉÌÎñÉϵĹºÂò· ......
OracleжÔØж²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
OracleжÔØж²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
ÓÃoracleµÄжÔسÌÐò²¢²»ÄÜÍêȫжÔظɾ»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêȫжÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
&nbs ......
Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......
Oracle 9i¹²ÌṩÁË16ÖÖ±êÁ¿Êý¾ÝÀàÐÍ£¬Èç±í7.4Ëùʾ¡£
±í7.4 Oracle 9iµÄ±êÁ¿Êý¾ÝÀàÐÍ
Ãû³Æ
º¬Òå
Char
ÓÃÓÚÃèÊö¶¨³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
varchar2
ÓÃÓÚÃèÊö±ä³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=4000×Ö½Ú
nchar
ÓÃÀ´´æ´¢Unicode×Ö·û¼¯µÄ¶¨³¤×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=1000×Ö½Ú
nvarchar2
ÓÃÀ´´æ´¢Un ......