在Oracle中，有可能“插入”一列转换成表？ [英] In Oracle, is it possible to "insert" a column into a table?

问题描述

在向现有表中添加列时，Oracle始终将列放在表的末尾。是否可以告诉Oracle它应该出现在表中？如果是，如何？

When adding a column to an existing table, Oracle always puts the column at the end of the table. Is it possible to tell Oracle where it should appear in the table? If so, how?

推荐答案

表格中列的位置不重要（除非有页面大小考虑，或者任何Oracle用来实际存储数据）。对消费者来说更重要的是如何调用结果，即Select语句。

The location of the column in the table should be unimportant (unless there are "page sizes" to consider, or whatever Oracle uses to actually store the data). What is more important to the consumer is how the results are called, i.e. the Select statement.

这篇关于在Oracle中，有可能“插入”一列转换成表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！