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

oracle jobºÅʹÓÃ

µ±ÓÃsubmit½¨JOBʱ£¬JOBIDÓÉϵͳ×Ô´øSEQUENCE£ºsys.JOBSEQÉú³É¡£
Èç¹ûÒ»¶Îʱ¼äºóJOBID¹ý´ó£¬¿ÉÒÔDROP SEQUENCE sys.JOBSEQ;ÔÙÖØ½¨
create sequence JOBSEQ
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
cache 20;
À´ÖØÐ¿ªÊ¼JOBID¡£
¿ÉÒÔÓÃÏÂÃæÓï¾ä¸üÐÂÒѾ­½¨Á¢µÄJOBID£º
UPDATE sys.Job$
SET job=5 WHERE job=62;
COMMIT;
¿ÉÒÔÓÃisubmitÀ´Ö¸¶¨JOBID½¨JOB


Ïà¹ØÎĵµ£º

PostgreSQLºÍOracleÓ÷¨ÉϵÄÒ»Ð©Çø±ð

£¨1 £© ×¢ÒâÔö¼ÓÔ¼ÊøÊ±µÄд·¨£¬ºÍORACLE ÂÔÓв»Í¬
Oracle £º
ALTER TABLE SCHEMA.PREFIX_INFO ADD (
CONSTRAINT PK_PREFIX_INFO PRIMARY KEY (INFO_ID));
PostgresQL £º
alter table schema.prefix_info add constraint prefix_info_pkey primary key(info_id);
£¨2 £©ÏµÍ³Ä¬ÈϵÄ×î´óÖµÓëORACLE ²»Í¬
Oracle £ ......

OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ

Ê×ÏÈÓÃÒ»¸öÃüÁÓèuserÓû§connect½ÇÉ«ºÍresource½ÇÉ«£º
grant connect,resource to user;
ÔËÐгɹ¦ºóÓû§°üÀ¨µÄȨÏÞ:
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE DATABASE LINK --½¨Á¢Êý¾Ý¿âÁ´½Ó
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREAT ......

OracleÖÐÌí¼ÓJob

OracleÖÐÌí¼ÓJob
 --ÿ15·ÖÖÓ trunc(sysdate+1/96,'MI')/*5:Mins*/ sysdate + 5/(60*24)
SQL> variable jobno number;
SQL> begin
  2  dbms_job.submit(:jobno,'´æ´¢¹ý³ÌÃû;',sysdate,'/*1:Hr*/ sysdate + 1/24' );
  3  commit;
  4  end;
  5  /
......

Oracle Warehouse Builder 11g ʹÓÃÈëÃÅ

ÔÚ±¾½Ì³ÌÖУ¬Äú½«Ê¹ÓÃÉèÖÃÎļþÅäÖà Oracle Warehouse Builder 11g µÚ 1 °æ (OWB 11gR1) µÄÏîÄ¿»·¾³¡£È»ºó£¬Äú½«´´½¨Ò»¸ö Warehouse Builder Óû§²¢µÇ¼¡£
ËùÐèʱ¼ä
´óÔ¼ 30 ·ÖÖÓ
×¢£º OWB 11g ÉèÖýű¾µÄÏÂÔØËµÃ÷ÔÚ±¾½Ì³ÌÉԺ󲿷ÖÌṩ¡£±¾½Ì³Ì¼°ÆäÉèÖýű¾½öÖ§³Ö OWB 11g µÚ 1 °æ¡£¸Ã Oracle ʾÀý½Ì³ÌµÄÔçÆÚ°æ±¾¿ÉÓÃÓÚ O ......

oracleÁ·Ï°£¨mldnÊÓÆµ¿Î³Ì£©ËÄ

ÊÓͼ
´´½¨ÐÂ±í£ºcreate table emp2 as select * from emp;
create view empv20 as select empno,ename,job,hiredate,deptno from emp where deptno=20 with check option;
Óï·¨£ºcreate or replace view ÊÓͼÃû³Æ as ×Ó²éѯ£¨ÐÞ¸ÄÖ®ºóµÄ×Ó²éѯ£©
Ìæ»»ÊÓͼ(ÐÞ¸Ä)
create or replace view empv20 as select empno,ename, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ