/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 votes276 views2 answers
Oracle multiple insert
SQL
3 votes293 views1 answer
Oracle apex call duration
SQL
6 votes313 views2 answers
Difference between join vs union
SQL
0 vote294 views1 answer
How to get first 10 records of a table in mysql
SQL
3 votes297 views2 answers
Sql get month name
SQL
1 vote303 views1 answer
Sql select max value from multiple rows
SQL
31 votes309 views2 answers
Grant all priviledges to mysql user
SQL
0 vote297 views1 answer
Can't connect to postgresql mac os
SQL
0 vote276 views1 answer
Version and edition of SQL Server Database Engine
SQL
10 votes325 views2 answers
Doublon sql
SQL