Oracle所有版本汇总
找到一个介绍oracle版本的文章。
http://wapedia.mobi/en/Oracle_Database#3.
■1979: Larry Ellison and friends founded Software Development Laboratories.
■1979: SDL changed its company-name to "Relational Software, Inc." (RSI) and introduced its product Oracle V2 as an early commercially-available relational database system. The version did not support transactions, but implemented the basic SQL functionality of queries and joins. (RSI never released a version 1 - instead calling the first version version 2 as a marketing gimmick.)[23]
■1982: RSI in its turn changed its name, becoming known as "Oracle Corporation",[24] to align itself more closely with its flagship product.
■1983: The company released Oracle version 3, which it had re-written using the C programming language and which supported COMMIT and ROLLBACK functionality for transactions. Version 3 extended platform support from the existing Digital VAX/VMS systems to include Unix environments.[24]
■1984: Oracle Corporation released Oracle version 4, which supported read-consistency.
■1985: Oracle Corporation released Oracle version 5, which supported the client-server model — a sign of networks becoming more widely available in the mid-1980s.
■1986: Oracle version 5.1 started supporting distributed queries.
■1988: Oracle RDBMS version 6 came out with support for PL/SQL embedded within Oracle Forms v3 (version 6 could not store PL/SQL in the database proper), row-level locking and hot backups.[25]
■1989: Oracle Corporation entered the application products market and developed its ERP product, (later to become part of the Oracle E-Business Suite), based on the Oracle relational database.
■1990: the release of Oracle Applications release 8[24]
■1992: Oracle version 7 appeared with support for referential integrity, stored procedures and triggers.
■1997: Oracle Corporation released version 8, which supported object-
相关文档：
如何定义游标类型
TYPE ref_type_name IS REF CURSOR [RETURN return_type];
声明游标变量
cursor_name ref_type_name;
从技术底层看，两者是相同的。普通plsql cursor在定义时是“静态”的。而Ref cursors可以动态打开。
例如下面例子：
Declare
type rc is ref cursor;
cursor c is select * from dual ......
Oracle Process Structure
Oracle takes advantage of various types of processes:
—User process: Started at the time a database user requests connection to the Oracle server
—Server process: Connects to the Oracle instance and is started when a user establishes a session
& ......
Oracle在自己机器上装一个有必要的，毕竟有时候需要自己在家学习一下，但电脑不是自己用的，还是写个批处理解决一下，需要的时候点击一下启动，不需要就停止，很方便。这里将脚本给大家写一个，欢迎大家粘贴拷贝。
首先，自己先将自己的自动启动服务关闭，并记录一下，然后替换脚本中相应的服务名称即可。自己粘贴出 ......
【引用】http://tangshd.blog.sohu.com/96035768.html
Oracle多行记录合并/连接/聚合字符串的几种方法
怎么合并多行记录的字符串，一直是oracle新手喜欢问的SQL问题之一，关于这个问题的帖子我看过不下30个了，现在就对这个问题，进行一个总结。
什么是合并多行字符串（连接字符串）� ......
在数据库未启动之前登陆从而启动数据库如果没有口令文件，在数据库未启动之前就只能通过操作系统认证.使用Rman，很多时候需要在nomount,mount等状态对数据库进行处理。所以通常要求sysdba权限如果属于本地DBA组，可以通过操作系统认证登陆如果是远程sysdba登陆，需要通过passwordfile认证。
1.remote_login_passwordfile ......
