default со ссылкой на таблицу

create table Table1
(
  ID               INTEGER not null,
  NAME     VARCHAR2(13) default 'XX-'||TRIM(TO_CHAR(ID,'000000000')),  
)

create table Table1
(
  ID               INTEGER not null,
  NAME     VARCHAR2(13) default 'XX-'||TRIM(TO_CHAR(ID,'000000000')),  
)

create table test_Table1
(
  ID               INTEGER not null,
  NAME     VARCHAR2(13) as ('XX-'||TRIM(TO_CHAR(ID,'000000000')))
)

CREATE TABLE "S1"."TEST_TABLE1" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"NAME" VARCHAR2(13) GENERATED ALWAYS AS ('XX-'||TRIM(TO_CHAR("ID",'000000000'))) VIRTUAL VISIBLE 
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
  ALTER TABLE "S1"."TEST_TABLE1" MODIFY ("ID" NOT NULL ENABLE);

create table S1.TABLE1
(
  ID               INTEGER not null,
  NAME             VARCHAR2(200) not null,
  ORGANIZATION     VARCHAR2(25) not null,
  FORMAT           VARCHAR2(50),
  PURPOSE          VARCHAR2(50),
  GROUP_ID         INTEGER,
  PROTOCOL_ID      INTEGER,
  RUN_DATE         DATE,
  VERSION_NAME     VARCHAR2(125),
  CATEGORY         VARCHAR2(50),
  NAME_ID     VARCHAR2(13) default 'NA-'||TRIM(TO_CHAR("ID",'000000000')),
  CREATED_ON       TIMESTAMP(6),
  CREATED_BY       INTEGER,
  MODIFIED_ON      TIMESTAMP(6),
  MODIFIED_BY      INTEGER
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );