/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 votes227 views1 answer
Sql ends with string
SQL
1 vote246 views3 answers
How to reset id column in sql server
SQL
0 vote251 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote215 views1 answer
Oracle execute immediate quotes
SQL
0 vote220 views1 answer
How to see password mysql vestacp
SQL
0 vote229 views1 answer
Except in sql
SQL
0 vote225 views1 answer
T sql check active deadlock
SQL
0 vote232 views1 answer
Insert array into mysql column
SQL
0 vote241 views1 answer
Sql pivot table
SQL
1 vote259 views1 answer
Oracle columns table
SQL