oracle sequenceÖµÖØÖûØ1
declare
n number(10);
tsql varchar2(100);
begin
select test_seq.nextval into n from dual;
n:=-(n-1);
tsql:='alter sequence test_seq increment by'|| n;
execute immediate tsql;
select test_seq.nextval into n from dual;
tsql:='alter sequence test_seq increment by 1';
execute immediate tsql;
end;
Ïà¹ØÎĵµ£º
ÎÒÏàÐÅÎÒÃǸÕѧoracle£¬¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬¶¼ÊÇÔÚ±¾µØ½øÐеģ¬Ö»Òª±£Ö¤¼àÌý·þÎñÆô¶¯£¬ÄÇôÎÒÃǾͿÉÒÔÕý³£Ê¹ÓÃsqlplus¶ÔÊý¾Ý¿â½øÐвéѯ£¬µ«ÊǼÙÈçÎÒÃÇÏ£Íûͨ¹ýÔ¶³Ì¶ÔÊý¾Ý¿âÀ´·ÃÎÊÄØ£¬´ËʱÎÒÃǾÍÒª¶Ôoracle¼àÌý½øÐÐÅäÖá£
oracle¼àÌýÅäÖÃÓÐÈý¸öÎļþ£¬ÎªÁË·½±ãÃèÊö£¬ÎÒÓÃserverºÍclientÀ´Çø·Ö£ ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ÏÔʾֵ:07
yyy three digits ÈýλÄê &nbs ......
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂÆµÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the c ......
½«±í¿Õ¼äºÍÊý¾ÝÎļþ´ÓÒ»¸öλÖÃÒÆ¶¯µ½ÁíÒ»¸öλÖõIJÙ×÷·½·¨
Ò»£® OFFLINE
OFFLINE ·ÖΪALTER DATABASE Óë ALTER TABLESPACE OFFLINE£¬
ËûÃǵÄÇø±ð²Î¿´blog£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/29/4898800.aspx
°´Êý¾ÝÎļþÀ´£º
1.ÏȽ«ÏàÓ¦µÄÊý¾ÝÎļþ offline
ALTER DATABASE DATAFILE 'D:\OR ......
OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆÎªsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È»ºóÔÙ´ ......