oracle¿Í»§¶ËÓ¦´ðÎļþ
oracle.client 9.0.1.0.0
©À1-Oracle Programmer 9.0.1.0.0
©¦ ©ÀOracle Call Interface (OCI) 9.0.1.0.0
©¦ ©ÀObject Type Translator 9.0.1.0.0
©¦ ©¸Pro*C/C++ 9.0.1.0.0
©À2-Oracle Enterprise Manager Products 9.0.1.0.0
©¦ ©¸Oracle Enterprise Manager Client 9.0.1.0.0
©À3-Oracle Net Services 9.0.1.0.0
©¦ ©¸Oracle Net Protocol Support 9.0.1.0.0
©¸4-Oracle Universal Installer 2.0.1.4.0
µ«ÆäÖеÄORACLE_HOMEºÍfrom_LOCATION¡¢LOCATION_FOR_DISK2¡¢LOCATION_FOR_DISK3¡¢LOCATION_FOR_DISK4Ò»¶¨ÒªÉèÖÃΪÕýÈ·µÄ·¾¶¡£
#══════════════════════════════════════════════════════════════════════════#
# Ó¦´ðÎļþ¿ªÊ¼
#══════════════════════════════════════════════════════════════════════════#
[General]
RESPONSEFILE_VERSION=1.7.0
[SESSION]
#Parameter: UNIX_GROUP_NAME
#Type: String
#Description: Unix group to be set for the inventory directory. Valid only in Unix platforms.
#Example : UNIX_GROUP_NAME = "install"
UNIX_GROUP_NAME=<Value Unspecified>
#Parameter: from_LOCATION
#Type: String
#Description: Complete path of t
Ïà¹ØÎĵµ£º
ºÜ¶àÅóÓÑÔÚJava¿ª·¢ÖУ¬Ê¹ÓÃOracleÊý¾Ý¿âµÄʱºò£¬¾³£»áÅöµ½ÓÐORA-01000: maximum open cursors exceeded.µÄ´íÎó¡£
ʵ¼ÊÉÏ£¬Õâ¸ö´íÎóµÄÔÒò£¬Ö÷Òª»¹ÊÇ´úÂëÎÊÌâÒýÆðµÄ¡£
ora-01000: maximum open cursors exceeded.
±íʾÒѾ´ïµ½Ò»¸ö½ø³Ì´ò¿ªµÄ×î´óÓαêÊý¡£
ÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔÒòÊÇ£ºJava´úÂëÔÚÖ´ ......
Oracle µÄrownum ÔÀíºÍʹÓÃ
ÔÚOracle ÖУ¬Òª°´Ìض¨Ìõ¼þ²éѯǰNÌõ¼Ç¼£¬Óøörownum ¾Í¸ã¶¨ÁË¡£
select * from emp where rownum <= 5
¶øÇÒÊéÉÏÒ²¸æ½ë£¬²»ÄܶÔrownum ÓÃ">"£¬ÕâÒ²¾ÍÒâζ×Å£¬Èç¹ûÄãÏëÓÃ
select * from emp where rownum > 5
ÔòÊÇʧ°ÜµÄ¡£ÒªÖªµÀΪʲô»áʧ°Ü£¬ÔòÐèÒªÁ˽ârownum ±³ºóµÄ»úÖÆ£ ......
Á·Ï°:
drop table Employee;
create table Employee(
id number primary key,
  ......
ÁÙʱ±íµÄ¸ÅÄ
ÔÚOracleÊý¾Ý¿âÖл¹ÓÐÒ»ÖÖÀàÐÍµÄ±í£¬½Ð×öÁÙʱ±í¡£Õâ¸öÁÙʱ±í¸úÓÀ¾Ã±í×î´óµÄÇø±ð¾ÍÊDZíÖеÄÊý¾Ý²»»áÓÀÔ¶µÄ´æÔÚ¡£µ±Ò»¸ö»á»°½áÊø»òÕßÊÂÎñ½áÊøµÄʱºò£¬Õâ¸öÁÙʱ±íÖеÄÊý¾Ý£¬²»ÓÃÓû§×Ô¼ºÉ¾³ý£¬Êý¾Ý¿â×Ô¼º»á×Ô¶¯Çå³ý¡££¨±íÊÇÈ«¾Ö£¬Ö»ÊÇÊý¾ÝÏûʧ£©
O ......