A column that is not existing in a table of the database, but that is calculated at access time.
A column that is not existing in a table of the database, but that is calculated at access time.
Questions tagged [virtual-column]
50 questions
0
votes
1 answer
MySQL change virtual column based on WHERE clause
Is it possible to change a virtual column value based on a where clause?
I have this table:
[computername] [computerlocation] [starttime] [endtime]
computer, siteA, 1457537657, 1457532657
computer2, siteB, …
Josh Budd
- 13
- 3
0
votes
0 answers
How to select a list as a virtual column in MySql?
I know I can select a single value using
SELECT 'value' AS col;
But I need return a list of numbers as a column. Something like
SELECT ('value1', 'value2', 'value3') AS col;
More precisely I need to do
SELECT * FROM my_table
INNER JOIN (SELECT…
Alan Alves de Oliveira
- 663
- 1
- 8
- 21
0
votes
0 answers
ora-01733 virtual column not allowed here
I have a variable, vTipoIdCompartido, reported that the name of a column. But it seems you can not do it that way because it gives me error 'ora-01733 virtual column not allowed here', every time I use it. Do I have to do differently?
create or…
kowalcyck
- 103
- 3
- 11
0
votes
3 answers
How to create alphanumeric sequence using date and sequence number
I want to create an alphanumeric sequence in oracle. Table name is rel_details it consists of four columns.
rel_id
rel_name
rel_modified_date
rel_desc
In rel_id i want to generate ID like REL230420151001
REL is a string ,
23042015 is today's…
Tapajyoti Giri
- 39
- 2
- 2
- 13
0
votes
1 answer
Oracle virtual column, date and timestamp
I have a problem in Oracle, with a virtual column (I need the timestamp starting from a date column); here my example:
CREATE TABLE TBDATETIME(
DATETIME_1 DATE,
DATETIME_2 TIMESTAMP(9) GENERATED ALWAYS AS (
CAST( TO_CHAR(DATETIME_1,…
user1
- 556
- 2
- 6
- 22