ÔÚ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µÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆÎªsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È»ºóÔÙ´ ......
declare
n number(10);
tsql varchar2(100);
begin
select test_seq.nextval into n from dual;
n:=-(n-1);
tsql:='alter ......
ǰÌìÓÐÈËÌáÁËÐèÇó£¬Ïë¶Ôij¸ö×ֶνøÐа´Î»µÄ»ò²Ù×÷¡£±¾À´½¨Òé²éѯ³öÀ´Ö®ºóÔÚÓ¦ÓóÌÐòÀïÃæ´¦Àí£¬µ«ÊÇÊý¾ÝÁ¿±È½Ï´ó£¬¾õµÃ»¹ÊÇ·µ»ØÒ»¸ö·Ö×鼯ËãÖ®ºóµÄÖµ±È½ÏºÏÊÊ¡£
Á½¸öÎÊÌ⣬һ¸öÊǰ´Îª»òµÄ²Ù×÷£¬Õâ¸ö²Î¿¼Á˱ðÈ˵ÄÎĵµ£¬ÓÃbitandº¯ÊýʵÏÖ¡£ ÔÎÄÈçÏ£º
http://blog.chinahr.com/blog/hewy0526/post/112968
È»ºó¾ÍÊÇ×Ô¶¨ÒåµÄ ......
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 ......
Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
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 ......