virtual-columns Archives

Constant values in columns

By adminPosted on May 5, 2023

Question : I have a SQL Server 2000 database used by our ERP system. There are many columns that always […]

By adminPosted on April 14, 2023

Question : I have two tables and I would like to generate a query relating the tables. Until now I […]

By adminPosted on August 5, 2022

Question : I have the following function: CREATE FUNCTION UUID_AS_HEX(bytes IN RAW) RETURN CHAR DETERMINISTIC IS uuid CHAR(36); BEGIN RETURN […]

By adminPosted on July 30, 2022

Question : I have a table id name 1 Alpha 2 Alpha 3 Beta 4 Charlie 5 Charlie I want […]

By adminPosted on June 9, 2022

Question : I’m not sure what technology I need because I’m not a DBA, but I’m sure there’s a good […]

By adminPosted on May 16, 2022

Question : I’m wondering whether exists any database engine that can share cells or rows amongst many tables. For example: […]

By adminPosted on March 3, 2022

Question : We want to update the condition of a virtual column and to minimize error posibilites we want to […]

By adminPosted on February 15, 2022

Question : In our environment, we usually add and drop generated columns every now and then. There is a very […]

By adminPosted on October 30, 2021

Question : Does anyone know of any Oracle dictionary views that hold references of ‘real’ columns to virtual columns? For […]

By adminPosted on November 11, 2020

Question : I have two tables and I would like to generate a query relating the tables. Until now I […]