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

oracle ÐòÁÐ

ÐòÁУ¨SEQUENCE£©ÐòÁÐÊÇÒ»Êý¾Ý¿â¶ÔÏó£¬ÀûÓÃËü¿ÉÉú³ÉΨһµÄÕûÊý¡£Ò»¸öÐòÁеÄÖµÊÇÓÉÌØÊâµÄOracle³ÌÐò×Ô¶¯Éú³É£¬Òò´ËÐòÁбÜÃâÁËÔÚÓ¦Óà ²ãʵÏÖÐòÁжøÒýÆðµÄÐÔÄÜÆ¿¾±¡£¸ÃÐòÁÐΪÉÏÉýÐòÁУ¬ÓÉ1¿ªÊ¼£¬ÔöÁ¿Îª1£¬Ã»ÓÐÉÏÏÞ¡£ÔÚÉýÐòʱ£¬ÐòÁпɴӱÈ×îСֵ´óµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×îСֵ¡£¶ÔÓÚ½µ Ðò£¬ÐòÁпÉÓɱÈ×î´óֵСµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×î´óÖµ¡£ÐÞ¸ÄÐòÁпÉÒÔ£º? ÐÞ¸ÄδÀ´ÐòÁÐÖµµÄÔöÁ¿¡£
ORACLEûÓÐÏóSQL SERVERÖÐÒ»ÑùµÄ×ÔÔö¼Ó×ֶΣ¬ÒªÊµÏÖÖ»ÄÜͨ¹ýSEQUENCEÀ´ÊµÏÖ
1.´´½¨ÐòÁУº
create sequence your_seq
nocycle
maxvalue 9999999999
start with 1;
2.ʹÓô¥·¢Æ÷ʵÏÖ×ÔÔö£º
create or replace trigger your_seq_tri
before insert on your_table1 for each row
declare
  next_id number;
begin
  select your_seq.nextval into next_id from dual;
  :new.id := next_id;
end;
ÔÚoraclekÖУ¬ÎªÁË·½±ãÎÒ³£³£Óô¥·¢Æ÷¼°ÐòÁнáºÏÆðÀ´ÊµÏÖ£¬ÏÂÃæ¾ÍÊÇÒ»¸öʾÀý¡£
ÏȽ¨±í¡¢ÔÙ½¨ÐòÁС¢È»ºóÊÇ´¥·¢Æ÷£¬×îºó²âÊÔ=============================================
--ΪÖ÷¼üÖ¸¶¨ÐòÁбàºÅ
--2003-10-8 15:53
=============================================
conn scott/tiger@powermis
drop table foo;
create table foo(
  id number primary key,
  data varchar2(100));
create sequence foo_seq;
create or replace trigger bifer_foo_id_pk
  before insert
    on foo
    for each row
begin
  select foo_seq.nextval into :new.id from dual;
end;
/
insert into foo(data)
  values('Chirstopher');
insert into foo(id,data)
  values(5,'Sean');
select * from foo;
Oracle8iÒýÈëÁËSYS_GUIDÕâ¸ö¸ÅÄËüͬOracle¹ÜÀíÔ±ËùʹÓõĴ«Í³µÄÐòÁУ¨sequence£©Ïà±È¾ßÓÐÖî¶àÓÅÊÆ¡£Ò»¸öÐòÁÐÉú³ÉÆ÷Ö»ÊǼòµ¥µØ´´½¨´Ó¸ø¶¨µÄÆðµã¿ªÊ¼µÄһϵÁÐÕûÊýÖµ£¬¶øÇÒËü±»ÓÃÔÚÑ¡Ôñ³ÂÊöʽµÄʱºò×Ô¶¯µØµÝÔö¸ÃϵÁС£
ÐòÁÐÉú³ÉÆ÷ËùÉú³ÉµÄÊý×ÖÖ»Äܱ£Ö¤ÔÚµ¥¸öʵÀýÀïÊÇΨһµÄ£¬Õâ¾Í²»ÊʺϽ«ËüÓÃ×÷²¢ÐлòÕßÔ¶³Ì»·¾³ÀïµÄÖ÷¹Ø¼ü
×Ö£¬ÒòΪ¸÷×Ô»·¾³ÀïµÄÐòÁпÉÄÜ»áÉú³ÉÏàͬµÄÊý×Ö£¬´Ó¶øµ¼Ö³åÍ»µÄ·¢Éú¡£SYS_GUID»á±£Ö¤Ëü´´½¨µÄ±êʶ·ûÔÚ
ÿ¸öÊý¾Ý¿âÀï¶¼ÊÇΨһµÄ¡£
´ËÍ⣬ÐòÁбØÐëÊÇDML³ÂÊöʽµÄÒ»²¿·Ö£¬Òò´ËËüÐèÒªÒ»¸öµ½Êý¾Ý¿âµÄÍù·µ¹ý³Ì£¨·ñÔòËü¾Í


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

¡¾×ª¡¿Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ


Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ
Kaya ·¢±íÓÚ os2ora.com
дÁËLinuxÉÏµÄ¼à¿ØÓë·ÖÎö¹¤¾ß
Ö®ºó£¬Ð´Ð´OracleÉÏÏàÓ¦µÄ¼à¿ØÓë·ÖÎö¹¤¾ß»¹ÊÇͦÓÐÒâ˼µÄ£¬Ò»·½Ãæ¿ÉÒÔ¸ü¼ÓÍêÕû£¬Ò»·½Ãæ¿ÉÒÔ½øÐкáÏò¶Ô±È¡£
LinuxÉϵÄÐÔÄÜÊý¾ÝÒ»°ã¶¼À´×ÔÓÚ/procÎļþϵͳ£¬¶øOracleÔòÊÇÀ´×ÔÓÚV$ÊÓͼ¡£Òò´Ë£¬ËùÓеÄOracle¼à¿Ø¹¤¾ßµÄʵÏÖ¶¼Íò±ä²»Àë
V$
ÊÓͼ¡ ......

OracleÓû§È¨ÏÞ¿ØÖÆ

1£©¡¢¹¹ÔìʵÀý£º
ÎÒÃÇÒѾ­´´½¨ºÃÊý¾Ý¿âÓû§test_user£¬Ï±ߴæÔÚtest_table±íºÍtest_procedure´æ´¢¹ý³Ì¡£ÎÒÃÇÒѾ­´´½¨ºÃÒ»¸ö¿ÕµÄ´úÀíÊý¾Ý¿âÓû§agent_user¡£
2£©¡¢µÇ¼test_userÓû§£¬½«test_userϱíµÄselectȨÏ޺ʹ洢¹ý³ÌµÄexcuteȨÏÞ¸³¸ø´úÀíÓû§agent_user¡£
SQL>GRANT select ON test_table TO agent_user;
SQL ......

oracle %type

1¡¢Ê¹ÓÃ%TYPE
ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿
DECLARE
v_FirstName VARCHAR2(20);
µ«ÊÇÈç¹ûfirst_nameÁе͍Òå¸Ä±äÁ˻ᷢÉúʲô£¨±ÈÈç˵±í¸Ä±äÁË£¬first ......

oracleÖÐTranslate()º¯ÊýÓ÷¨

  Ò»¡¢Óï·¨£º  
    TRANSLATE(string,from_str,to_str)  
  ¶þ¡¢Ä¿µÄ  
      ·µ»Ø½«£¨ËùÓгöÏֵģ©from_strÖеÄÿ¸ö×Ö·ûÌæ»»Îªto_strÖеÄÏàÓ¦×Ö·ûÒÔºóµÄstring¡£TRANSLATEÊÇREPLACEËùÌṩµÄ¹¦ÄܵÄÒ»¸ö³¬¼¯¡£Èç¹ûfrom_str±È  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ