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;
Ïà¹ØÎĵµ£º
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......
ÏÂÃæÊÇORACLEÐÐÁÐת»»Í¨Óô洢¹ý³Ì£º
1¡¢
Function Fun_Split_Str(p_Str Varchar2, p_Division Varchar2, p_Seq Int)
Return Varchar2 Is
v_First Int;
v_Last Int;
Begin
If p_Seq < 1 Then
&nbs ......
OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
1¡¢ ÄÚ´æ½á¹¹£º
OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
ÿ¸öOracleÊý¾Ý¿â¶¼ÊÇÓÉOracle Instance£¨ÊµÀý£©ÓëÊý¾Ý¿â£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ£©×é³É£¬ÆäÖÐËùνʵÀý¾ÍÊÇÓû§Í¬Êý¾Ý¿â½»»¥µÄý½é£¬Óû§Í¨¹ýÓÚÒ»¸öʵÀýÏàÁ¬À´²Ù×÷Êý¾Ý¿â¡£¶øÊµÀýÓÖÊÇÓÉͳһµÄÄÚ´æ½á¹¹£¨SGA£¬PGA£¬UGA£©ºÍ ......
1.´´½¨²âÊÔ±í
create table users(
userid int primary key,
username varchar2(20),
userpwd varchar2(20)
);
insert into users values(1,'test','test');
insert into users values(2,'test','test');
insert into users values(3,'test','test');
insert into users values(4,'test','test');
insert i ......