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

ÕÆÎÕµÄOracle¶¨Ê±ÈÎÎñ

 Ò»¡¢ÔÚPLSQLÖд´½¨±í£º
 
create table HWQY.TEST
(
CARNO VARCHAR2(30),
CARINFOID NUMBER
)
¶þ¡¢ÔÚPLSQLÖд´½¨´æ´¢¹ý³Ì£º
 
create or replace procedure pro_test
AS
carinfo_id number;
BEGIN
select s_CarInfoID.nextval into carinfo_id
from dual;
insert into test(test.carno,test.carinfoid) values(carinfo_id,''123'');
commit;
end pro_test;
Èý¡¢ÔÚSQLÃüÁî´°¿ÚÖÐÆô¶¯ÈÎÎñ£º
ÔÚSQL>ºóÖ´ÐУº
 
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
''pro_test;'',
SYSDATE,''sysdate+1/24/12'');

commit;
end;
/
Ìá½»ºóÌáʾ£º
 
Ó¢ÎÄ´úÂë
ËÄ¡¢¸ú×ÙÈÎÎñµÄÇé¿ö(²é¿´ÈÎÎñ¶ÓÁÐ)£º
 
SQL> select job,next_date,next_sec,failures,broken from user_jobs;
JOB NEXT_DATE NEXT_SEC FAILURES BROKEN
---------- ----------- ---------------- ---------- ------
1 2008-2-22 ?01:00:00 0 N
 
 
˵Ã÷ÓÐÒ»¸öÈÎÎñ´æÔÚÁË¡£
Ö´ÐÐselect * from test t²é¿´¶¨Ê±ÈÎÎñµÄ½á¹û¡£¿ÉÒÔ¿´³ö¶¨Ê±ÈÎÎñÊÇÕý³£Ö´ÐÐÁ˵ġ£
 
Î塢ֹͣÒѾ­Æô¶¯µÄ¶¨Ê±ÈÎÎñ:
ÏÈÖ´ÐÐselect job,next_date,next_sec,failures,broken from user_jobs;
ÒԲ鿴¶¨Ê±ÈÎÎñµÄjobºÅ¡£
ÔÚSQL>ÖÐÖ´ÐÐÏÂÃæµÄÓï¾äÍ£Ö¹Ò»¸öÒѾ­Æô¶¯µÄ¶¨Ê±ÈÎÎñ£º
 
begin
dbms_job.remove(1);
commit;
end;
/
±íʾֹͣjobΪ1µÄÈÎÎñ¡£
Ö´ÐкóÏÔʾÈçÏ£º
 
PL/SQL procedure successfully completed
Áù¡¢²é¿´½ø³ÌÊý£º
 
show parameter job_queue_processes;
±ØÐë>0£¬·ñÔòÖ´ÐÐÏÂÃæµÄÃüÁîÐ޸ģº
alter system set job_queue_processes=5;
Æß¡¢ÔÙ´´½¨Ò»¸öÈÎÎñ(ÿ5·ÖÖÓÖ´ÐÐÒ»´Î)£º
 
variable jobno number;
begin
dbms_job.submit(:jobno, ''pro_test;'',
sysdate,''sysdate+1/24/12'');
commit;
end;
/
½¨Á¢Ò»¸ö¶¨Ê±ÈÎÎñºó£¬ÔÚPLSQLÖв鿴JOB£¬ËüµÄsqlÓï¾äÀàËÆµÄÊÇÈçÏ£º
 
begin
sys.dbms_job.submit(job => :jobno,
what => ''pro_test;'',
next_date => to_date(''21-02-2008 17:37:26'', ''dd-mm-yyyy hh24:mi:ss''),
interval => ''sysdate+1/24/12'');
commit;
end;
/
ËùÒÔ£¬´´½¨Ò»¸öÈÎÎñµÄÍêÕûµÄ¸ñʽÊÇ£º
variable jobno number;
begin


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

sql serverÖÐinºÍexistsµÄÐ¡Çø±ð oracleδ²âÊÔ

in µÄ»°£¬ Èç¹ûÊÇnull ¾Í²»±È½ÏÁË£¬¼È²»ÊÇin Ò²²»ÊÇ not in
existsµÄ»° ÒòΪÓà = ¼ÓÔÚÌõ¼þÀï±È½ÏÁË£¬ËùÒÔ null ÊÇ not exists
select *
from pricetemp
where cast(ÉÌÆ·¥³ー¥É as varchar(10))not in(
           select shohin_cd
  &nbs ......

ORACLEÖв鿴SQLÖ´Ðмƻ®µÄ·½·¨

 1.Ê×ÏÈÐèÒª½¨Á¢plan table,·ñÔò²»ÄÜʹÓÃ
½¨Á¢·½·¨£º
$oracle\rdbms\adminÏÂÓиö
utlxplan.sql
ÆäÄÚÈÝΪ:
create table PLAN_TABLE (
 statement_id  varchar2(30),
 timestamp     date,
 remarks       varchar2(80),
 operat ......

Oracle OSÈÏÖ¤ÒÔ¼°¿ÚÁîÎļþ

1.OSÈÏÖ¤
Oracle°²×°Ö®ºóĬÈÏÇé¿öÏÂÊÇÆôÓÃÁËOSÈÏÖ¤µÄ£¬ÕâÀïÌáµ½µÄosÈÏÖ¤ÊÇÖ¸·þÎñÆ÷¶ËosÈÏÖ¤¡£OSÈÏÖ¤µÄÒâ˼°ÑµÇ¼Êý¾Ý¿âµÄÓû§ºÍ¿ÚÁîУÑé·ÅÔÚÁ˲Ù×÷ϵͳһ¼¶¡£Èç¹ûÒÔ°²×°OracleʱµÄÓû§µÇ¼OS£¬ÄÇô´ËʱÔڵǼOracleÊý¾Ý¿âʱ²»ÐèÒªÈκÎÑéÖ¤£¬È磺
SQL> connect /as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect sys/aaa@test as ......

oracleʵ¼ù

1.
´íÎóÌáʾ£ºORA-12545:ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ,Á¬½Óʧ°Ü.
´íÎóÖ¢×´£ºÐ½¨µÄÊý¾Ý¿âÔÚOEM¿ØÖÆÌ¨ÎÞ·¨ÏÔʾ£¨sysmanÓû§µÇ½£©£¬¶ÀÁ¢Æô¶¯Ä£Ê½¿ÉÒÔÕÒµ½£¬µ«ÎÞ·¨µÇ½£¬³öÏÖÈçÉÏ´íÎó¡£
½â¾ö°ì·¨£ºÐÞ¸Äoracle°²×°Ä¿Â¼Ï£¨oracle\ora90\network\ADMIN£©µÄtnsnames.oraÎļþ£¬½«µ±Ç°Êý¾Ý¿âÌí¼Óµ½¼àÌý¶ÔÏóÖС£ÐÞ¸ÄÖ®ºó£¬¿ÉÒÔÔÚ¶ÀÁ¢Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ