×îÐÂoracle ²¹¶¡ÏÂÔØ
×îÐÂoracle ²¹¶¡ÏÂÔØ
ʹÓÃѸÀ×н¨ÈÎÎñÏÂÔØµØÖ·Ìîд
ftp://updates.oracle.com/<patch_num>/p<patch_num>_<version>_<os>.zip
¾Í¿ÉÒÔÏÂÔØµ½ÄãÏëÒªµÄ²¹¶¡ÁË¡£
ÒÔÏÂÊǼ¸¸ö³£Óò¹¶¡µÄÏÂÔØµØÖ·¡£
(10.2.0.3 patch)
ftp://updates.oracle.com/5337014/p5337014_10203_WINNT.zip ftp://updates.oracle.com/5337014/p5337014_10203_LINUX.zip
oracle 9.2.0.8
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
oracle 9.2.0.6
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip
ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip
ÎÒ»¹ÓÐһЩÆäËüµÄ²¹¶¡ Èç¹ûÓÐÐèÒªÇëÁôÏÂÓÊÏä
9.2.0.7
ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip
ftp://updates.oracle.com/4163445/p4163445_92070_WINNT.zip
9.2.0.4 = 3095277
9.2.0.5 = 3501955
9.2.0.6 = 3948480
9.2.0.7 = 4163445
9.2.0.8 = 4547809£¨9i×îÖÕ£©
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189
oracle 9.2.0.4
ftp://updates.oracle.com/3095277/p3095277_9204_LINUX.zip
ftp://updates.oracle.com/3095277/p3095277_9204_WINNT.zip
oracle 9.2.0.5
ftp://updates.oracle.com/3501955/p3501955_9205_LINUX.zip
ftp://updates.oracle.com/3501955/p3501955_9205_WINNT.zip
oracle 9.2.0.6
ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip
oracle 9.2.0.7
ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip
ftp://updates.oracle.com/4163445/p4163445_92070_WINNT.zip
oracle 9.2.0.8(9i×îÖÕ°æ±¾)
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
10.1.0.5
ftp://updates.oracle.com/4505133/p4505133_10105_WINNT.zip
ftp://updates.oracle.com/4505133/p4505133_10105_LINUX.zip
10.2.0.2
ftp://updates.oracle.com/4547817/p4547817_10202_WINNT.zip
ftp://updates.oracle.com/4547817/p4547817_10202_LINUX.zip
10.2.0.3
ftp://updates.oracle.com/5337014/p5337014_10203_WIN
Ïà¹ØÎĵµ£º
oracleѧϰ±Ê¼Ç_´¥·¢Æ÷
´¥·¢Æ÷
ÊÇÌØ¶¨Ê¼þ³öÏÖµÄʱºò£¬×Ô¶¯Ö´ÐеĴúÂë¿é¡£ÀàËÆÓÚ´æ´¢¹ý³Ì£¬µ«ÊÇÓû§²»ÄÜÖ±½Óµ÷ÓÃËûÃÇ¡£
¹¦ÄÜ£º
1¡¢ ÔÊÐí/ÏÞÖÆ¶Ô±íµÄÐÞ¸Ä
2¡¢ ×Ô¶¯Éú³ÉÅÉÉúÁУ¬±ÈÈç×ÔÔö×Ö¶Î
3¡¢ Ç¿ÖÆÊý¾ÝÒ»ÖÂÐÔ
4¡¢ ÌṩÉó¼ÆºÍÈÕÖ¾¼Ç¼
5¡¢ ·ÀÖ¹ÎÞЧµÄÊÂÎñ´¦Àí
6¡¢ ÆôÓø´ÔÓµÄÒµÎñÂß¼
¿ªÊ¼
create trigger biufe ......
OracleÈ«ÎÄË÷ÒýµÄ»ù±¾ÖªÊ¶
Ò»¡¢ÀúÊ·±³¾°
OracleÊý¾Ý¿âµÄÈ«ÎļìË÷¼¼ÊõÒѾ·Ç³£ÍêÃÀ£¬Oracle TextʹOracle9i¾ß±¸ÁËÇ¿´óµÄÎı¾¼ìË÷ÄÜÁ¦ºÍÖÇÄÜ»¯µÄÎı¾¹ÜÀíÄÜÁ¦¡£Oracle TextÊÇOracle9i²ÉÓõÄÐÂÃû³Æ£¬ÔÚOracle8/8iÖÐËü±»³Æ×÷Oracle interMedia Text£¬ÔÚOracle8ÒÔǰËüµÄÃû³ÆÊÇOracle ConText Cartridge¡£
¶þ¡¢Oracle Text Ë÷Ò ......
1.desc(ÃèÊö£© emp ÃèÊöempÕâÕűí
2.desc dept ²¿Ãűí
3.desc salgrade нˮµÈ¼¶
4.select *from table ²éÕÒ±íÖеÄÔªËØ
5.dual &nbs ......
Ï£Íû¸ßÊÖ¿ÉÒÔ°ïæһÏ ²»Ê¤¸Ð¼¤
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on ÐÇÆÚËÄ 5ÔÂ 20 17:23:05 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn system/manager as sysdba;
ÒÑÁ¬½Óµ½¿ÕÏÐÀý³Ì¡£
SQL> ......