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

Oracle×ÔÔöIDµÄ½â¾ö°ì·¨

Ê×ÏÈ´´½¨Ò»¸öË÷Òý£¬È»ºó´´½¨Ò»¸ö´¥·¢Æ÷
Ë÷ÒýµÄÃû×Ö£º SEQ_tproduct
´¥·¢Æ÷µÄÃû×Ö£º addid
±íÃû£ºtproduct
×ÔÔöÁÐÃû£ºpid
create sequence SEQ_tproduct                              
minvalue 1
start with 1
increment by 1
nocache;
create or replace trigger addid
before insert on tproduct
for each row 51Testing
begin
select SEQ_tproduct.nextval into :new.pid from dual;
end;


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

ÏÖoracle¹²ÏíÄÚ´æ²»×㣬ÕÐÖÂÊý¾Ý¿âû·¨Ò»°ãÊ©ÓÃ

ÈçÆä·¢ÏÖoracle¹²ÏíÄÚ´æ²»×㣬ÕÐÖÂÊý¾Ý¿âû·¨Ò»°ãÊ©Óã¬Ø½Ðè½øÕ¹ÄÚ´æ´¢Æ÷²ÎÊýÅú¸Ä£¬·½·¨Èç´Î£º
Ò»¡¢µÇ½Êý¾Ý¿â,²é¿´Ä¿Ç°Êý¾Ý¿âÔËÓõÄÊÇpfileÈÔÊÇspfile£¬Õý³£Çé¿ö϶¼ÊÇÔËÓÃspfileÆð¶¯.
¶þ¡¢´´Ôìpfile Ê©ÓÃcreate pfile from spfileÏÂÁÁ¢£¬×¥ºÃ±¸·Ý¡£
Èý¡¢Í¸¹ýeditplusµÈÎı¾¹¤¾ß´ò¿ª×ÊÁÏ,ÕûºÏ¾ßÌåµÄ²ÎÊý.Èç¹ûÔÚsolar ......

OracleÖÐÌÞ³ý±í,ÌÞ³ýÊý¾ÝÒÔ¼°»Ø¸´Êý¾Ý

Ò».ÌÞ³ý±íÖÐÊý¾ÝÁ½ÖÖ²½Öè
a. delete * from My_Table;
b. truncate table My_Table;
¶þ.ÌÞ³ýÕû¸ö±í
drop table My_Table;
ºÎÒԻظ´²»Ð¡ÐÄ Drop µôµÄ±íÄØ,ʵÔò Oracle ÖÐÒ²ÓÐÏà·ÂµÄ "»ØÊÕÕ¾"
ÀýÈ粻СÐÄÌÞ³ýÁ˱í My_Table
drop table My_Table;
Õâ¸öʱ·ÖÔÙÓÃSELECT»°Óï²éѯ´Ë±íʱ£¬½«»áÌáÐѱí»òÊÓͼ²»´æÔÚ.
µ«¿ÉÒÔÓ ......

ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ ¡¾×ª¡¿


ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ

×÷Õߣº[תÌù] ³ö´¦£º  

 
×î
½ü×öÒ»¸öJ2EEÏîÄ¿£¬ÐèÒªÔÚJSPÒ³ÃæʵÏÖ¶ÔÎļþµÄÉÏ´«ºÍÏÂÔØ¡£ºÜÔçÒÔÇ°¾ÍÖªµÀJDBCÖ§³Ö´ó¶ÔÏó£¨LOB£©µÄ´æÈ¡£¬ÒÔΪºÜÈÝÒ×£¬×öÆðÀ´²Å·¢ÏÖÎÊÌâ¶à
¶à£¬¶ÁÁËÒ»´ó¶ÑÎÄÕ£¬·´¶øûÓÐʲôͷÐ÷ÁË¡£ÕýÈçһλÍøÓÑÎÄÕÂËù½²£º“&h ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ