Sql add calculated column

-- MySQL / Oracle:
ALTER TABLE table_name ADD double_count NUMBER(10, 2)
    GENERATED ALWAYS AS (account * 2) VIRTUAL;
    
-- SQL Server
ALTER TABLE table_name ADD [double_count] AS (account * 2);

Source: mysqltutorial.org

Similar codes

0 vote210 views1 answer
How to compile a function in oracle
SQL
0 vote173 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote165 views1 answer
Sqlcmd no headers
SQL
1 vote172 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote165 views1 answer
Oracle list of long running queries
SQL
0 vote157 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote199 views2 answers
How to drop mili second in sql
SQL
0 vote176 views2 answers
Return the number of records in a single table mysql
SQL
0 vote173 views2 answers
Plsql function that return a table
SQL
0 vote173 views1 answer
Mariadb date equals to current_date plus days
SQL