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

OracleÔõôȡÏû±¸·Ý

ÎÒÔÚOEMÖнøÐÐÁ˱¸·Ý²Ù×÷£º±¸·Ý¹ÜÀí->±¸·Ý¡£
ÉèÖõÄÊÇÿÌ춨ʱ±¸·ÝÒ»´Î¡£
ÏÖÔÚµÄÎÊÌâÊDz»ÖªµÀÔõô°ÑÕâ¸ö±¸·ÝÈ¡Ïûµô£¬¾ÍÊDz»ÈÃËü×ö±¸·ÝÁË¡£
²éѯdba_jobs

ÒýÓÃ
²éѯdba_jobs

SQL code:

select dba_jobs from dual
*
ERROR λÓÚµÚ 1 ÐÐ:
ORA-00904: "DBA_JOBS": ÎÞЧµÄ±êʶ·û




ÒªÓÃÓÐȨÏÞµÄÓû§£¬±ÈÈçsysµÇ¼

ÒýÓÃ
ÒýÓà 1 Â¥ vc555 µÄ»Ø¸´:
²éѯdba_jobs

SQL codeselect dba_jobsfrom dual*
ERROR λÓÚµÚ1 ÐÐ:
ORA-00904: "DBA_JOBS": ÎÞЧµÄ±êʶ·û



ÊÇ
select * from dba_jobs;

ÒýÓÃ
ÒýÓà 2 Â¥ strwangfan µÄ»Ø¸´:
ÒýÓà 1 Â¥ vc555 µÄ»Ø¸´:
²éѯdba_jobs

SQL codeselect dba_jobsfrom dual*
ERROR λÓÚµÚ1 ÐÐ:
ORA-00904: "DBA_JOBS": ÎÞЧµÄ±êʶ·û


ÊÇ
select * from dba_jobs;

Õâ¸öÊDzéѯÎÒ×öµÄ±¸·ÝÂð£¿ÎªÊ²Ã´²éѯ½á¹ûÊǿգ¿
¿ÉÒÔÃ÷È·µÄÊÇ£¬ÎÒȷʵ×öÁ˱¸·Ý£¬Ã¿Ìì¶¼»á²úÉúÒ»¸ö±¸·ÝÎļþ¡£

OEM²»ÄÜÉèÖÃÂð£¿

OEMÖÐɾ³ý¡£

Server -> Scheduler Central -> Jobs ÖÐÕÒµ½¸Ãjob£¬È»ºódelete¡£

È¡Ïûµô¸Ãjob°¡£¡
select * from user_jobs

½ûÓÃJOB

<


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

javaµ÷´æ´¢¹ý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

´æ´¢¹ý³Ì£º
create or replace procedure insert_emp
 (empid in number,
 empname in varchar2,
 empsal in number)
 as
 begin 
  insert into emp(empno,ename ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ