Oracle´´½¨´¥·¢Æ÷
½ñÌìÔÚ°Ù¶ÈÉÏËÑË÷ÁËÏÂoracleдµÄ´¥·¢Æ÷£¬¸Ð¾õ»¹¿ÉÒÔ¡£
¾ÍÊղؿ©¡£
Óû§±í£º´´½¨´¥·¢Æ÷֮ǰÊ×ÏÈÒª´´½¨ÐòÁÐ
Óû§±íÐòÁУº
create sequence users_seq;
Óû§±í´¥·¢Æ÷£º
create or replace trigger bifer_users_userid_pk
before insert
on users
for each row
begin
select users_seq.nextval into:new.userid from dual;
end;
/
ÉÌÆ·±í£º
ÉÌÆ·±íÐòÁУºcreate sequence product_seq;
ÉÌÆ·±í´¥·¢Æ÷£º
create or replace trigger bifer_product_itemid_pk
before insert
on product
for each row
begin
select product_seq.nextval into:new.itemid from dual;
end;
/
ÉÌÆ·Æ·ÅÆ±í£º
ÉÌÆ·Æ·ÅƱíÐòÁУºcreate sequence brand_seq;
ÉÌÆ·Æ·ÅÆ±í´¥·¢Æ÷£º
create or replace trigger bifer_brand_brandid_pk
before insert
on brand
for each row
begin
select brand_seq.nextval into:new.brandid from dual;
end;
/
ÉÌÆ·Àà±ð±í£º
ÉÌÆ·±íÐòÁУºcreate sequence class_seq;
ÉÌÆ·±í´¥·¢Æ÷£º
create or replace trigger bifer_class_classid_pk
before insert
on class
for each row
begin
select class_seq.nextval into:new.classid from dual;
end;
/
Ò»¸ö´¥·¢Æ÷Ö»ÄÜÓÃÓÚÒ»¸ö±í£¬¶øÒ»¸ö±í¿ÉÒÔÓÐ×î¶àÈý¸ö´¥·¢Æ÷£¬ÉÌÆ·Æ·ÅÆÀà±ð±íÊǸ´ºÏÖ÷¼üËùÒÔ¾ÍΪÉÌÆ·±í½¨ÁËÁ½¸ö´¥·¢Æ÷·Ö±´×÷ÓÃÓÚÿ¸öÖ÷¼ü
ÉÌÆ·Æ·ÅÆÀà±ð±í£º
ÉÌÆ·Æ·ÅÆÀà±ðÐòÁУºcreate sequence brand_class_seq;
ÉÌÆ·Æ·ÅÆÀà±ð´¥·¢Æ÷(brandid)£º
create or replace trigger brand_class_brandid_pk
before insert
on brand_class
for each row
begin
select brand_class_seq.nextval into:new.brandid from dual;
end;
/
ÉÌÆ·Æ·ÅÆÀà±ð´¥·¢Æ÷(classid)£º
create or replace trigger brand_class_classid_pk
before insert
on brand_class
for each row
begin
select brand_class_seq.nextval into:new.classid from dual;
end;
/
ÔÚoracleÖУ¬ÎªÁË·½±ã³£³£Óô¥·¢Æ÷¼°ÐòÁнáºÏÆðÀ´ÊµÏÖ
ÏȽ¨±í¡¢ÔÙ½¨ÐòÁС¢È»ºóÊÇ´¥·¢Æ÷£¬×îºó²âÊÔ
=============================================
&
Ïà¹ØÎĵµ£º
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
ORACLEµÄlpadº¯Êý¡¢rpadº¯ÊýÓ÷¨
Óï·¨£ºselect lpad('12345678',1,'0') from dual;
·µ»Ø×Ö·û´®‘12345678’µÄ´Ó×ó±ß³¤¶ÈΪ1µÄ×Ö·û´®£¬Èç¹û²»¹»£¬×ó±ß²¹‘0’
Óï·¨£ºselect rpad('12345678',1,'0') from dual;
·µ»Ø×Ö·û´®‘12345678’µÄ´Ó×ó±ß³¤¶ÈΪ1µÄ×Ö·û´®£¬Èç¹û²»¹»£¬Óұ߲¹&ls ......
select sysdate µ±Ç°Ê±¼ä,
sys.login_user Êý¾Ý¿âÓû§,
machine µÇ¼»úÆ÷Ãû,
SYS_CONTEXT('USERENV', 'IP_ADDRESS') 怬IP,
&n ......
´¦Àí·½·¨Ò» £º
¼ì²éÄǸö±í±»Ëø
select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;
½âËø
alter system kill session '273,45';
´¦Àí·½·¨¶ ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......