Talk:Virtual column

Regarding Oracle and AUTOMATIC persistent virtual columns:

Talk:Virtual column

Regarding Oracle and AUTOMATIC persistent virtual columns:

Oracle_database does not have support for persistent virtual columns.

Oracle_Rdb does have support for persistent virtual columns, known as AUTOMATIC columns.

Oracle Rdb is a separate product from Oracle database, originally developed by DEC for VMS and later on bought by Oracle. Previous versions of this page said that Oracle had persistent virtual columns known as AUTOMATIC columns, but that doesn't appear to be the case - it looks like there was some confusion between Oracle Rdb and Oracle database.

  • Oracle documentation on CREATE TABLE statement makes no mention of AUTOMATIC columns or persistent virtual columns [1]
  • Oracle Rdb documentation specifically about the AUTOMATIC column feature gives a quick explanation on how they work and how they are different from computed columns [2]
  • General Rdb documentation explains usage of the feature in context [3] See page "7–70" i.e. page 82.

203.89.74.252 (talk) 00:38, 13 October 2017 (UTC)Reply

  1. ^ http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7002.htm
  2. ^ http://www.oracle.com/technetwork/database/rdb/automatic-columns-132042.pdf
  3. ^ http://download.oracle.com/otndocs/products/rdb/pdf/sql_ref_v7320_part3.pdf

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.