oracleÐòÁвÙ×÷
-- ÐòÁвÙ×÷ --
-- ´´½¨ÐòÁÐ
CREATE SEQUENCE u_sales_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
-- ²é³öËùÓдæÔÚµÄÐòÁÐ
SELECT * from user_sequences
-- ɾ³ýÐòÁÐ
DROP SEQUENCE U_SALES_SEQ;
-- ²é³öÏÂÒ»¸öÐòÁÐID
SELECT U_SALES_SEQ.nextval from DUAL
-- ²é³öµ±Ç°ÐòÁеÄID
SELECT U_SALES_SEQ.currval from DUAL;
¡¡¡¡2¡¢Alter Sequence
¡¡¡¡Äã»òÕßÊǸÃsequenceµÄowner£¬»òÕßÓÐALTER ANY SEQUENCE ȨÏÞ²ÅÄܸĶ¯sequence. ¿ÉÒÔalter³ýstartÖÁÒÔÍâµÄËùÓÐ
sequence²ÎÊý.Èç¹ûÏëÒª¸Ä±ästartÖµ£¬±ØÐë drop sequence ÔÙ re-create .
¡¡¡¡Alter sequence µÄÀý×Ó
¡¡¡¡ALTER SEQUENCE emp_sequence
¡¡¡¡INCREMENT BY 10
¡¡¡¡MAXVALUE 10000
¡¡¡¡CYCLE -- µ½10000ºó´ÓÍ·¿ªÊ¼
¡¡¡¡NOCACHE ;
¡¡¡¡Ó°ÏìSequenceµÄ³õʼ»¯²ÎÊý£º
¡¡¡¡SEQUENCE_CACHE_ENTRIES =ÉèÖÃÄÜͬʱ±»cacheµÄsequenceÊýÄ¿¡£
¡¡¡¡¿ÉÒԺܼòµ¥µÄDrop Sequence
¡¡¡¡DROP SEQUENCE order_seq;
¡¡--½¨´¥·¢Æ÷
¡¡¡¡CREATE OR REPLACE TRIGGER table1_tg
¡¡¡¡BEFORE INSERT ON table1
¡¡¡¡FOR EACH ROW
¡¡¡¡BEGIN
¡¡¡¡SELECT table1_seq.NEXTVAL INTO :NEW.id from DUAL;
¡¡¡¡END;
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
ÏÈ¿´ÏÂÃæµÄÀý×Ó:oracleÖÐÁ½¸öϵͳ±í.emp,dept.
example:
1:not exists(not in)
not exists:
ÕâÌõÓï¾ä·µ»Øselect * from scott.dept d where e.deptno=d.deptno and d.deptno=10Ìõ¼þÂú×ãµÄ½á¹û¼¯.Ò²¾ÍÊÇ˵,
·µ»ØµÄ½á¹û¼¯Öв»´æÔÚd.deptno=10½á¹û¼¯µÄ¼Ç¼,¼´emp±íÖÐûÓÐdept±íÖÐd.deptno=10µÄ¼Ç¼.
SQL& ......
How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Orac ......
Author: rainnyzhong
Date:2010-1-15
1£® Ö¢×´ÃèÊö£º
FALB12´ÓEXCEL IMPORT DATAµ½DB£¬Ô¤¼ÆÊÂÎñ»áÔËÐÐ1¸ö¶àСʱ£¬ÔÚ¿ªÊ¼²Ù×÷ºó40·ÖÖÓ×óÓÒ£¬ORACLE¹ÒËÀ£¬ÈκÎÓû§¶¼²»¿ÉÒÔÔٵǽÁË¡£
2£® ·ÖÎö
£¨1£© ÏÂÃæÊǹÒËÀʱOSµÄ×ÊÔ´×´¿ö£º
09:37:54 up 73 ......
×÷Õߣºeygle |English Version ¡¾×ªÔØʱÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2010/01/oracle_dba_notebook.html
½ñÌ죬ÊÕµ½Á˳ö°æÉç¿ìµÝ¶øÀ´µÄ¡¶Oracle DBAÊּǡ·Ò»ÊéµÄ24СʱСÑù£¬Õâ¸öСÑùͨ¹ýÖ®ºó£¬Êé¾Í¿ÉÒÔ³ÉÅúÓ¡Ë¢£¬Ö¸ÈÕ¿É´ýÁË¡£×î¿ìµÄ¹À¼ÆÊÇÏÂÖÜ¿ÉÒÔÉ ......