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-
    
     
	
	
    
    
	相关文档:
        
    
    Oracle主键自动增长
这几天搞Oracle,想让表的主键实现自动增长,查网络实现如下:
create table simon_example
(
  id number(4) not null primary key,
  name varchar2(25)
)
-- 建立序列:
-- Create sequence 
create sequence SIMON_SEQUENCE        &nb ......
	
    
        
    
    如何定义游标类型
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 ......
	
    
        
    
     select sysdate from dual; 从伪表查系统时间,以默认格式输出。
sysdate+(5/24/60/60) 在系统时间基础上延迟5秒
sysdate+5/24/60 在系统时间基础上延迟5分钟
sysdate+5/24 在系统时间基础上延迟5小时
sysdate+5 在系统时间基础上延迟5天
所以日期计算默认单位是天
round (sysdate,’day’) 不是四除 ......
	
    
        
    
    目录
==================================================================
1.带空值的排列
2.Top/Bottom N查询
3.First/Last排名查询
4.按层次查询
一、带空值的排列:
假如被排列的数据中含有空值呢?
SQL> select region_id, customer_id,
   2         ......
	
    
        
    
    界面: Default.aspx
 
界面上添加的控件:
两个TextBox: tEmail(用于输入用户email),tPassword(用于输入注册密码)
一个Button: bReg
一个Label: lLable(用于注册成功后显示应答)
Demo的代码: Default.aspx.cs
我们先把数据的连接字符串写在Web.config里:
<appSettings>
<add key="oracleconn" value= ......