oracle ×Ô¶¯Ôö³¤ÁÐ Àý×Ó
--´´½¨ÐòÁÐ
create sequence innerid
minvalue 1
maxvalue 999999999
start with 1
increment by 1
cache 20
order;
--´´½¨±í
create table users(
userid int primary key,
username varchar2(20),
userpwd varchar2(20)
);
select * from users;
insert into users values(innerid.nextval,'zhangsan','123');
insert into users values(innerid.nextval,'lisi','123');
insert into users values(innerid.nextval,'wangwu','123');
--´´½¨´¥·¢Æ÷
create or replace trigger users_id
before insert on users for each row
begin
select innerid.nextval into :new.userid from dual;
end users_id;
insert into users(username,userpwd) values('zhaoliu','123');
select * from users;
commit;
Ïà¹ØÎĵµ£º
Ê×ÏÈ£¬ÐèÒªÖØÐÂÕûÀíÒ»ÏÂÏà¹Ø¸ÅÄoracleÊý¾Ý¿âÖк¯ÊýµÄ×÷Óã¬ÊÇÖ»Äܱ»±ðÈ˵÷Ó㬴洢¹ý³Ì¿ÉÒÔµ¥¶ÀÖ´ÐУ¬²¢ÇÒ¿ÉÒÔµ÷Óô洢¹ý³Ì£¬¶ø°üµÄ×÷Óðü¿ÉÒÔ½«ÈκγöÏÖÔÚ¿éÉùÃ÷µÄÓï¾ä ( ¹ý³Ì , º¯Êý , Óαê , Óαê , ÀàÐÍ , ±äÁ¿ ) ·ÅÓÚ°üÖÐ , Ï൱ÓÚÒ»¸öÈÝÆ÷ . ½«ÉùÃ÷Óï¾ä·ÅÈë°üÖеĺô¦ÊÇ : Óû§¿ÉÒÔ´ÓÆäË ......
OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
1¡¢ ÄÚ´æ½á¹¹£º
OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
ÿ¸öOracleÊý¾Ý¿â¶¼ÊÇÓÉOracle Instance£¨ÊµÀý£©ÓëÊý¾Ý¿â£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ£©×é³É£¬ÆäÖÐËùνʵÀý¾ÍÊÇÓû§Í¬Êý¾Ý¿â½»»¥µÄý½é£¬Óû§Í¨¹ýÓÚÒ»¸öʵÀýÏàÁ¬À´²Ù×÷Êý¾Ý¿â¡£¶øÊµÀýÓÖÊÇÓÉͳһµÄÄÚ´æ½á¹¹£¨SGA£¬PGA£¬UGA£©ºÍ ......
¾³£ÓÃoracleµÄÈ˶ÔÏÂÃæµÄÕâÌõÐÅÏ¢¿Ï¶¨²»»áİÉú£º“¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ´½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ”¡£Æäʵ²úÉúÕâ¸öÎÊÌâµÄ¸ù±¾ÔÒò²»ÊǼàÌýûÓÐÆðÀ´£¬¶øÊǼàÌýûÓмàÌýÄãÒªÁ¬½ÓµÄoracleʵÀý¡£
´ó¼Ò¶¼Ã÷°×£¬oracleÖ»ÓÐÁ½Õ߼汸²ÅÄÜÏòÍâ½çÌṩ·þÎñ£ºÒ»¸öÊǼàÌý£¬ÓÃÓÚ½Ó ......
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶Î:
......
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
[A]Èç¹û¿ªÆô¹éµµ£¬Çë±£Ö¤log_archive_start=true¿ªÆô×Ô¶¯¹éµµ£¬·ñÔòÖ»ÄÜÊÖ¹¤¹éµµ£¬Èç¹ûÊǹرÕÁ˹鵵£¬ÔòÉèÖøòÎÊýΪfalse
×¢Ò⣺Èç¹ûÊÇOPS/RAC»·¾³£¬ÐèÒªÏȰÑparallel_server = true×¢Ê͵ô£¬È»ºóÖ´ÐÐÈçϲ½Ö裬×îºóÓÃÕâ¸ö²ÎÊýÖØÐÂÆô¶¯
1¡¢¿ªÆô¹éµµ
a. ¹Ø±ÕÊý¾Ý¿âshutdown im ......