Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¶¨Ê±Ö´Ðд洢¹ý³ÌµÄjob

±¾ÎÄ×ªÔØ:http://blog.csdn.net/flm_0722/archive/2009/10/08/4643566.aspx
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
......

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

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

Oracle Ê±ÇøÎÊÌâ

oracleÖеÄtz_offsetÊÇÓÃÀ´·µ»Ø¸ø¶¨Ê±ÇøÓë±ê×¼Ê±Çø(UTC universal of time Coordinate ͨÓÃʱ¼ä×ø±ê)µÄÆ«ÒÆÁ¿£¬Æä²ÎÊý¿ÉÒÔÊÇ£º
1.Ò»¸öºÏ·¨µÄÊ±ÇøÃû
2.Ò»¸öÀëUTCµÄ±ê×¼Æ«ÒÆÁ¿
3.¹Ø¼ü×ÖSessionTimeZone»òÕßÊÇDB_timezone
 
ÆäÖкϷ¨µÄÊ±ÇøÃû¿ÉÒÔ´ÓϵͳÊÓͼV$TimeZone_namesÖеÄÁÐTZnameÖеĵõ½£º
TZNAME
— ......

Oracle ¿ØÖÆÎļþ

Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECORD ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ