oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü
oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü
°ÑÏÂÃæµÄµØÖ·¸´ÖƵ½Ñ¶À×Àï¾Í¿ÉÒÔÏÂÔØ.
---------------------------------------------------------------------------------------------------
ORACLE 9i
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit)
http://download.oracle.com/otn/n ... 2021Win64_Disk1.zip
http://download.oracle.com/otn/n ... 2021Win64_Disk2.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux
http://download.oracle.com/otn/l ... linux_disk1.cpio.gz
http://download.oracle.com/otn/l ... linux_disk2.cpio.gz
http://download.oracle.com/otn/l ... linux_disk3.cpio.gz
Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/l ... _9204_Disk1.cpio.gz
http://download.oracle.com/otn/l ... _9204_Disk2.cpio.gz
http://download.oracle.com/otn/l ... _9204_Disk3.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX - Based 4.3.3 Systems (64-bit)
http://download.oracle.com/otn/a ... AIX64_Disk1.cpio.gz
http://download.oracle.com/otn/a ... AIX64_Disk2.cpio.gz
http://download.oracle.com/otn/a ... AIX64_Disk3.cpio.gz
http://download.oracle.com/otn/a ... AIX64_Disk4.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX- Based 5L Systems
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-01.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-02.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-03.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-04.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit)
http://download.oracle.
Ïà¹ØÎĵµ£º
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
´æ´¢
ÔÚSqlServerÖУ¬ÎÒÃÇ¿ÉÒÔΪһ¸öÊý¾Ý¿âÖ¸¶¨Ò»×éÎļþ¡£Êý¾Ý´æ´¢ÔÚÕâЩÎļþÖС£
& ......
ÏȼÙÉèÓÐÕâôһ¸ö±í£º
create
table
S_Depart (
DepartId
INT
& ......
1.ÊÓͼ£¨VIEW£©
1.1 ¸ÅÄî
ÊÓͼ-----ÊÇÓÉSELECT²éѯÓï¾ä(¿ÉÒÔÊǵ¥±í»òÕ߶à±í²éѯ)¶¨ÒåµÄÒ»¸ö"Âß¼±í",Ö»Óж¨Òå¶øÎÞÊý¾Ý,ÊÇÒ»¸ö"Ðé±í". ÔÚ´´½¨ÊÓͼʱ,Ö»Êǽ«ÊÓͼµÄ¶¨ÒåÐÅÏ¢±£´æÔÚÊý¾Ý×ÖµäÖÐ, ¶ø²¢²»½«Êµ¼ÊµÄÊý¾Ý¸´ÖƵ½Èκεط½, ¼´²»ÐèÒªÔÚ±í¿Õ¼äÖÐΪÊÓͼ·ÖÅä´æ´¢¿Õ¼ä. ÊÓͼÊDz鿴º ......
start d:\a.sql
@ d:\a.sql
edit [d:\a.sql]
spool d:\a.sql ½«ÆÁÉÏÄÚÈÝ Êä³öµ½Ö¸¶¨Îļþ
spool off
set linesize 320
set pagesize 100
set autoprint on
set serveroutput on
variable v1 refcursor
exp imp ±¸·Ý »Ö
Ö»¶ÁÊÂÎñ
set transaction read only
Óô¦£¬ÉèÖà ......