CREATE TABLE "XX_CHARACTERISTICS"
( "AD_CLIENT_ID" NUMBER(10,0) DEFAULT NULL,
"AD_ORG_ID" NUMBER(10,0),
"ISACTIVE" CHAR(1),
"CREATED" DATE,
"CREATEDBY" NUMBER(10,0),
"UPDATED" DATE,
"UPDATEDBY" NUMBER(10,0),
"A_ASSET_ID" NUMBER(10,0),
"XX_CHARACTERISTIC_ID" NUMBER(10,0) DEFAULT NULL,
"ASSETGROUP_ID" NUMBER(10,0) DEFAULT NULL,
"NAME" VARCHAR2(100),
"CREATED_BY" VARCHAR2(100),
"CREATED_DATE" DATE,
"UPDATED_BY" VARCHAR2(100),
"UPDATED_DATE" DATE,
CONSTRAINT "XX_CHARACTERISTIC_PK" PRIMARY KEY ("XX_CHARACTERISTIC_ID") ENABLE
)
/
Fig 1 Creating form from table

fig 2 Steps for calling and creating forms from tables

Fig 3 Functional Form for insert/update new created table characteristics

Нема коментара:
Постави коментар