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

²éѯOracle×Ô´øµÄ·½·¨Ãû×ֺ͹ؼü×Ö

ÈçºÎ²éѯoracleÖеĹؼü×Ö£¬Ö´ÐУº
select * from v$reserved_words
ÆäʵÄÚǶµÄfunction£¬¾ÍÊÇÒ»¸öϵͳµÄpackageÄÚµÄfunction»òÕßprocedure¡£Èç¹ûÖªµÀÕâ¸ö¸ù±¾µÄÔ­Òò£¬ÒªÕÒµ½Õâ¸öÄÚǶµÄ×Ô´øfunction¾ÍºÜ¼òµ¥ÁË¡£
ÕâÀïÄÚǶµÄ×Ô´øµÄfucntionºÍprocedureµÄ¶ÔÏ󣬯äʵ¾ÍÊÇSTANDARDÕâ¸ö°üÀïµÄ¶ÔÏó¡£¶ø
OracleÀï¶ÔÓÚfunction£¬package£¬procedure¶¼ÊÇÔÚdba_proceduresϵÁеÄÊý¾Ý×ÖµäÀïµÄ
ËùÒÔÕâÀïµÄ¸øÄãµÄ´ð°¸ÊÇ
select distinct PROCEDURE_NAME from dba_procedures where OBJECT_NAME = 'STANDARD';


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

28.4.1 ÊÖ¹¤Æô¶¯ºÍ¹Ø±ÕOracle·þÎñ

28.4.1  ÊÖ¹¤Æô¶¯ºÍ¹Ø±ÕOracle·þÎñ
OracleÊý¾Ý¿â·þÎñÓÉÁ½²¿·Ö×é³É£ºÊý¾Ý¿â½ø³ÌºÍÍøÂç¼àÌýÆ÷½ø³Ì£¬ËüÃÇ·Ö±ð¿Éͨ¹ýsqlplusºÍlsnrctlÃüÁî¿ØÖÆÆô¶¯¹Ø±Õ¡£
1£®Êý¾Ý¿â½ø³Ì
ʹÓÃDBCA¹¤¾ß´´½¨Êý¾Ý¿âºó£¬Æä½ø³ÌÒѾ­×Ô¶¯Æô¶¯£¬ÕâЩ½ø³Ì¶¼ÊÇÒÔÊý¾Ý¿âÃû³Æ£¨ÔÚ±¾ÀýÖÐΪorcl£©ÃüÃû£¬ÈçÏÂËùʾ¡£
 
$ ps -ef|grep orcl
orac ......

28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM

28.5  OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔ­À´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄÜ ......

¡¶Í¿Ä¨Oracle£­Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç

¡öÀÖÖª
  “Ë­ÊÇË­µÄË­”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾­µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......

Oracle job ʹÓÃ

²½Ö裺
(1) ´´½¨×÷Òµ
(2) ´´½¨job
       dbms_job.submit();
       submit ( jobno¡¡OUT binary_ineger,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡What¡¡¡¡¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡next_date IN¡¡date,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡interval¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ