/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 vote197 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote193 views1 answer
Get number of tables in database sql
SQL
1 vote209 views1 answer
Best sql course
SQL
0 vote221 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote192 views1 answer
Update top 100 sql
SQL
6 votes256 views3 answers
Mysql remove user privileges
SQL
1 vote216 views1 answer
Mysql update inner
SQL
2 votes209 views1 answer
Mysql select default if null
SQL
0 vote843 views2 answers
Remove mysql workbench ubuntu
SQL
6 votes272 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL