/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

0 vote222 views1 answer
Flask_sqlalchemy install
SQL
0 vote277 views1 answer
What does leave do in mysql
SQL
0 vote271 views1 answer
Sql select lowest value row
SQL
0 vote276 views1 answer
Name '_mysql' is not defined
SQL
0 vote256 views1 answer
Pip install mysqlclient error
SQL
0 vote255 views1 answer
Mysql docker image for macbook m1
SQL
0 vote256 views1 answer
Find most frequent value in SQL column
SQL
4 votes241 views2 answers
How to count items with same name in sql
SQL
0 vote274 views1 answer
Supprimer les valeur d'une table mysql
SQL
3 votes364 views1 answer
How to get yesterday date in sql
SQL