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

oracle»ù´¡ÎÊÌâ

oracle Database 10g Release 2ÖеÄrelease 2ÊÇʲôÒâ˼£¿

ÎÒ°²×°Oracle Database 10g Release 2 (10.2.0.1.0) ºÍ Oracle Datebase 10g £¨10.1.0.2.0£©Ã»Ì«´óÇø±ð°É£¿


ÒÔÉÏ2¸ö°æ±¾Çø±ðÊÇʲô£¿

¾ÍÊÇÒ»¸ö°æ±¾ºÅ°É
(10.2.0.1.0)
ÔÚ£¨10.1.0.2.0£©µÄ»ù´¡ÉϽøÐÐÁËÒ»¶¨µÄÐÞÕý
ÐÞ¸ÄÁËÄÄЩµØ·½£¬Ó¦¸ÃÄÜÔÚ¹ÙÍøÀï²éµ½

ÀýÈ磺oracle 9.0.1.1.2
¡¡¡¡
9£º°æ±¾ºÅ
0£ºÐÂÌØÐÔ°æ±¾ºÅ
1£¨µÚÒ»¸ö£©£ºÎ¬»¤°æ±¾ºÅ
1£¨µÚ¶þ¸ö£©£ºÆÕͨµÄ²¹¶¡ÉèÖúÅÂë
2£ºÌØÊâµÄƽ̨²¹¶¡ÉèÖúÅÂë  vnc serverÅäÖÃ

ÒýÓÃ
ÀýÈ磺oracle 9.0.1.1.2
¡¡¡¡
9£º°æ±¾ºÅ
0£ºÐÂÌØÐÔ°æ±¾ºÅ
1£¨µÚÒ»¸ö£©£ºÎ¬»¤°æ±¾ºÅ
1£¨µÚ¶þ¸ö£©£ºÆÕͨµÄ²¹¶¡ÉèÖúÅÂë
2£ºÌØÊâµÄƽ̨²¹¶¡ÉèÖúÅÂë  vnc serverÅäÖÃ


Õý½â°¡£¡

ѧϰÀ²£¡

·Ç³£¸Ðл¥Éϸ÷λ

ûÓÐʲô̫´óµÄÇø±ð!!

Çø±ð²»´ó

ѧϰһÏÂ


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

oracle²éѯÎÊÌâ

ÎÒÒª²éѯµ±Ç°Óû§µÄËùÓбíÒÔ¼°±í×¢Ê͵ÄsqlÓ¦¸ÃÔõôдÄØ

select table_name,comment from user_tables

´ó¼Ò°ïÎÒ¿´¿´ÕâÌõsql´íÔÚÄÄÀï
user_tablesÀïûÓÐcomment×Ö¶Î
Ïë¿´×¢Ê͵Ļ°
select * from ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ