/SQL/Oracle sql add column auto generated value

Oracle sql add column auto generated value

create table t2( col_name varchar2(10) );

insert into t2(col_name) values('hsaJDadkD');

ALTER TABLE t2 ADD (col_name2 GENERATED ALWAYS AS (SUBSTR(col_name,-3))); --virtual column

Select * from T2;

COL_NAME   COL_NAME
---------- --------
hsaJDadkD  dkD

Source: stackoverflow.com

Similar codes

1 vote114 views1 answer
How to get alternate records from a table in sql
SQL
0 vote127 views2 answers
Mysql dump structure only
SQL
0 vote112 views1 answer
Convert rows into columns in oracle
SQL
4 votes108 views1 answer
Sql quote in string
SQL
0 vote114 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote173 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote107 views1 answer
Temp table vs variable table in sql server
SQL
0 vote74 views1 answer
Store query result in variable sql
SQL
0 vote114 views1 answer
Mysql group by range
SQL
0 vote124 views1 answer
WHERE not regex in SQL
SQL