/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 vote144 views1 answer
Oracle sql date summer time
SQL
0 vote139 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote138 views1 answer
Find all tables where column name exists oracle
SQL
1 vote136 views2 answers
Sql groub by count
SQL
0 vote133 views1 answer
Can we rollback deleted data in sql
SQL
1 vote159 views1 answer
Psql connect
SQL
10 votes151 views2 answers
What is database
SQL
0 vote132 views1 answer
See the structure of a table mysql
SQL
0 vote131 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote147 views1 answer
Mysql limit order by
SQL