Oracle数据库中主键的智能生成

The Intelligent Generating of Primary Key in Oracle Database

介绍了一种在Oracle数据库中利用序列和触发器智能生成数据库表主键的方法。通过对所创建的一个简单地主键智能生成器的测试和分析,发现了单纯用行级触发器生成主键存在的局限性,并给出了相应的解决办法。

A method for generating primary key intelligently with sequence and trigger in Oracle database is illustrated in this article. By testing and analyzing the Intelligent primary key generator, a potential problem is found,which is caused by using a row level trigger in generating primary key and a solution is put forward.