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

ÔÚoracle±íÖÐÔõÑù´´½¨×ÔÔö³¤×Ö¶Î

.½¨Á¢²âÊÔÊý¾Ý±í
CREATE TABLE TEST
(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(20)
);
2.´´½¨ÐòÁÐ
CREATE SEQUENCE SEQ_TEST;
3.´´½¨´¥·¢Æ÷
CREATE OR REPLACE TRIGGER AUTOINCREMENT
BEFORE INSERT ON TEST
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT SEQ_TEST.NEXTVAL INTO :NEW.ID from DUAL;
END;
/
4.²åÈëÊý¾Ý
INSERT INTO TEST(NAME) VALUES('increase');
5.²é¿´²åÈë½á¹û
SELECT * from TEST;


Ïà¹ØÎĵµ£º

Oracle sqlplus ³£ÓÃÃüÁî×ܽá

OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆÎªsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È»ºóÔÙ´ ......

oracle sequenceÖµÖØÖûØ1

declare 
  n   number(10); 
  tsql   varchar2(100); 
  begin 
  select   test_seq.nextval   into   n   from   dual; 
  n:=-(n-1); 
  tsql:='alter   ......

Ò»¸öOracle×Ô¶¨Òå¾Û¼¯º¯ÊýµÄÀý×Ó

ǰÌìÓÐÈËÌáÁËÐèÇó£¬Ïë¶Ôij¸ö×ֶνøÐа´Î»µÄ»ò²Ù×÷¡£±¾À´½¨Òé²éѯ³öÀ´Ö®ºóÔÚÓ¦ÓóÌÐòÀïÃæ´¦Àí£¬µ«ÊÇÊý¾ÝÁ¿±È½Ï´ó£¬¾õµÃ»¹ÊÇ·µ»ØÒ»¸ö·Ö×鼯ËãÖ®ºóµÄÖµ±È½ÏºÏÊÊ¡£
Á½¸öÎÊÌ⣬һ¸öÊǰ´Îª»òµÄ²Ù×÷£¬Õâ¸ö²Î¿¼Á˱ðÈ˵ÄÎĵµ£¬ÓÃbitandº¯ÊýʵÏÖ¡£ Ô­ÎÄÈçÏ£º
http://blog.chinahr.com/blog/hewy0526/post/112968
È»ºó¾ÍÊÇ×Ô¶¨ÒåµÄ ......

Oracle ±í¿Õ¼ä»ù±¾²Ù×÷

1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M;
3.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING CONTENTS ......

Oracle ¹éµµÓë·Ç¹éµµµÄÇл»

Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
select name,log_mode from v$database;
Ò²¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä
archive log list£»(¸Ã·½·¨ÐèÒªas sysdba)
SQL> archive log list
Database log mode ¡¡¡¡¡¡¡¡¡¡¡¡No Archive Mode
Automatic archival¡¡¡¡¡¡¡¡¡¡¡¡Disabled
Archive destination¡¡¡¡¡¡¡¡¡¡ /export/home ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ