我想在oracle中停止列的标识，所以如何关闭它 [英] I want to stop identity of column in oracle so how to off that

问题描述

我想在oracle中停止列的标识，因此如何关闭该

I want to stop identity of column in oracle so how to off that

推荐答案

Oracle中没有这样的东西.搜索关联的序列.

Oracle支持用于生成主键值的序列.序列不绑定到表中的特定列.为了在Oracle中获得相同的身份键效果"，您可以创建触发器以自动将序列值分配给列.这也意味着序列与表或列之间没有直接链接.许多用于Oracle数据库管理和开发的商业软件应用程序，例如Toad for Oracle，已经实现了合并操作并简化此操作的过程.起初，这听起来很麻烦.但是，它既有效又灵活得多.

有关序列的更多信息?
http://download.oracle.com/docs/cd/B28359_01/server. 111/b28310/views002.htm [ ^ ]
http://download.oracle.com/docs/cd/E10405_01/doc/appdev.120/e10406/dialogs.htm#BACJCCFJ [

There is no such a thing in Oracle. Search for the associated sequence.

Oracle supports sequences for generating primary key values; sequences are not tied to a particular column in a table. To get the same "Identity key effect" in Oracle, you can create a trigger to automatically assign sequence values to a column. This also means that there is no direct link between the sequence and the table or column. Many of commercial software application for administration and development of Oracle Database, as Toad for Oracle, already implements the procedures that combines actions and simplify this operation. At first, this sounds cumbersome. However, it is as effective and a good deal more flexible too.

More information about Sequences?
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/views002.htm[^]
http://download.oracle.com/docs/cd/E10405_01/doc/appdev.120/e10406/dialogs.htm#BACJCCFJ[^]


Cheers!

这篇关于我想在oracle中停止列的标识，所以如何关闭它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！