/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 votes218 views1 answer
Drop table if exists in postgres
SQL
0 vote264 views2 answers
Oracle chain rules
SQL
2 votes226 views1 answer
How to select first row of database sql
SQL
0 vote256 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
11 votes231 views4 answers
Query DISTINCT
SQL
1 vote221 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote262 views1 answer
Cube oracle
SQL
2 votes227 views2 answers
Install sqlalchemy
SQL
0 vote325 views1 answer
Restart serial number for postgres
SQL
0 vote226 views1 answer
Select count postgres double row count > 1
SQL