/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 vote142 views10 answers
John the ripper mysql
SQL
0 vote127 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote243 views1 answer
Oracle convert int to date
SQL
0 vote107 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote130 views1 answer
What is mysql_pconnect
SQL
3 votes126 views2 answers
See mysql users ubuntu
SQL
1 vote103 views1 answer
Index a database column sql
SQL
0 vote150 views1 answer
Mysql error codeigniter
SQL
0 vote132 views1 answer
Count database access django
SQL
0 vote118 views1 answer
How to update date value in sql
SQL