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£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
´æ´¢¹ý³Ì£º create or replace procedure insert_emp (empid in number, empname in varchar2, empsal in number) as begin insert into emp(empno,ename ......