/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 votes150 views1 answer
Q operator in plsql
SQL
3 votes162 views1 answer
Oracle limit user tablespace
SQL
9 votes162 views2 answers
Oracle all tables in schema
SQL
0 vote165 views3 answers
Insert query in ci
SQL
9 votes139 views3 answers
Show table columns mysql command line
SQL
5 votes149 views1 answer
Mysql count lines
SQL
-1 vote217 views5 answers
Left join
SQL
0 vote166 views1 answer
Load data infile mariadb slow
SQL
2 votes147 views1 answer
Oracle find constraints referencing a table
SQL
1 vote163 views1 answer
Create index concurrently postgres
SQL