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ÅäÖÃ
Õý½â°¡£¡
ѧϰÀ²£¡
·Ç³£¸Ðл¥Éϸ÷λ
ûÓÐʲô̫´óµÄÇø±ð!!
Çø±ð²»´ó
ѧϰһÏÂ
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
ÎÒÒª²éѯµ±Ç°Óû§µÄËùÓбíÒÔ¼°±í×¢Ê͵ÄsqlÓ¦¸ÃÔõôдÄØ
select table_name,comment from user_tables
´ó¼Ò°ïÎÒ¿´¿´ÕâÌõsql´íÔÚÄÄÀï
user_tablesÀïûÓÐcomment×Ö¶Î
Ïë¿´×¢Ê͵Ļ°
select * from ......