/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

2 votes158 views1 answer
Add default sql server
SQL
15 votes161 views2 answers
How to know the username of postgresql
SQL
1 vote168 views1 answer
Mysql select if empty result
SQL
0 vote163 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote114 views2 answers
Postgresql could not start server mac
SQL
0 vote197 views1 answer
Mysql c commands
SQL
7 votes157 views2 answers
MySQL IF without else
SQL
1 vote160 views2 answers
How to check if sql query is correct online
SQL
0 vote162 views1 answer
Get last date join sql
SQL
0 vote162 views1 answer
Oracle list dblink
SQL