Oracle 12c --Invisible Columns 可隱藏列
2024-08-29 13:55:00
供稿:網(wǎng)友
Invisible Columns 可隱藏列 ( Oracle 12c release 1版本引入新功能 ) An invisible column is a user-specified column whose values are only visible when the column is explicitly specified by name. You can add an invisible column to a table without affecting existing applications, and make the column visible if necessary. 一個(gè)隱藏列的列是在指定列的值僅列時(shí)可見顯式指定的名字。您可以添加一個(gè)看不見的列一個(gè)表在不影響現(xiàn)有應(yīng)用程序,如果必要的,可以使列可見。 In general, invisible columns help migrate and evolve online applications. A use case might be an application that queries a three-column table with a SELECT * statement. Adding a fourth column to the table would break the application, which expects three columns of data. Adding a fourth invisible column makes the application function normally. A developer can then alter the application to handle a fourth column, and make the column visible when the application goes live. 一般來說,看不見列幫助遷移和發(fā)展在線應(yīng)用程序。一個(gè)用例可能是一個(gè)應(yīng)用程序,該應(yīng)用程序可以查詢一個(gè)三列的表 SELECT *聲明。第四列添加到表會(huì)破壞應(yīng)用程序,預(yù)計(jì)三列的數(shù)據(jù)。添加第四個(gè)無形的列使應(yīng)用程序正常運(yùn)轉(zhuǎn)。開發(fā)人員可以改變應(yīng)用程序來處理第四列,并使列可見當(dāng)應(yīng)用程序上線。 The following example creates a table PRoducts with an invisible column count, and then makes the invisible column visible: 下面的示例創(chuàng)建一個(gè)表 products一個(gè)隱藏列 ,然后使無形的列count可見: CREATE TABLE products ( prod_id INT, count INT INVISIBLE ); ALTER TABLE products MODIFY ( count VISIBLE ); See Also: Oracle Database Administrator’s Guide to learn how to manage invisible columns Oracle Database SQL Language Reference for more information about invisible columns 參見: Oracle數(shù)據(jù)庫管理員指南學(xué)習(xí)如何管理無形的列 Oracle數(shù)據(jù)庫SQL語言參考關(guān)于看不見的更多信息列