/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

3 votes355 views2 answers
Sql server current date without time
SQL
4 votes409 views4 answers
Check constraint in ms sql
SQL
1 vote334 views2 answers
Sql multiline comment
SQL
0 vote380 views2 answers
Temp tables in sql server
SQL
0 vote288 views1 answer
Import sql file in mysql linux
SQL
1 vote373 views1 answer
Where not in array sql
SQL
8 votes364 views2 answers
Alert table name mysql
SQL
0 vote359 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote345 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote374 views1 answer
Postgresql substring last
SQL