使用数据库从序列对象生成的ID进行Oracle视图创建 [英] Oracle View Creation with a Database generated ID from a Sequence Object

问题描述

我可以使用数据库生成的主键创建oracle视图"吗?

Can i create an oracle "View" with a DB generated Primary Key?

我想创建一个视图，其ID是一个来自Sequence对象的数据库生成的ID.

I want to create a view with its ID being a DB generated ID from a Sequence object.

推荐答案

您不能完全做到这一点，但是可以执行以下操作:

You can't do exactly that, but you can do something like this:

select rownum, field1, field2
  from...

rownum是一个精确生成的字段，但是在排序记录之前已被分配，因此，如果您有ORDER BY子句，则必须执行以下操作:

the rownum is an aoutogenerated field that holds exactly that, but it's assigned BEFORE ordering records, so if you have an ORDER BY clause, then you'll have to do this:

Select rownum, *
  from (select ....
         order by ....)

这篇关于使用数据库从序列对象生成的ID进行Oracle视图创建的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！