TABLE REGISTRATION

PROCEDURE REGISTER_TABLE
(APPLICATION_SHORTNAME IN VARCHAR2
,TABLE_NAME IN VARCHAR2
,TABLE_TYPE IN VARCHAR2
,NEXE_EXTENT IN NUMBER DEFAULT 512
,PCT_FREE IN NUMBER DEFAULT 10
,PCT_USED IN NUMBER DEFAULT 70);

PROCEDURE REGISTER_COLUMN
(
APPLICATION_SHORT_NAME IN VARCHAR2
,COL_NAME IN VARCHAR2
,COL_SEQ IN NUMBER
,COL_TYPE IN VARCHAR2
,COL_WIDTH IN NUMBER
,NULLABLE IN VARCHAR2
,TRANSLATABLE IN VARCHAR2
,PRECISION IN NUMBER DEFAULT NULL
,SCALE IN NUMBER DEFAULT NULL)


TABLE REGISTRATION IN HR MODULE

create table XXEMPLOYEEDTLS
(
EMPID NUMBER
,E_NAME VARCHAR2(100)
,E_LASTNAME VARCHAR2(100)
,E_FIRST_NAME VARCHAR2(100)
,E_JOIN_DATE DATE
,E_POSITION VARCHAR2(100)
,E_PROJECT VARCHAR2(100)
,E_HRA NUMBER
,E_TAX NUMBER
,E_PF NUMBER
,E_TOTALSALARY NUMBER
,E_PACKAGE NUMBER
,LAST_UPDATED_BY NUMBER
,LAST_UPDATE_LOGIN NUMBER
,CREATION_DATE DATE
,CREATED_BY NUMBER
,LAST_UPDATE_DATE DATE
,ATTRIBUTE1 VARCHAR2(100)
,ATTRIBUTE2 VARCHAR2(100)
,ATTRIBUTE3 VARCHAR2(100)
,ATTRIBUTE_CATEGORY VARCHAR2(100)
)

);

grant all on xxemployeedtls to apps


CREATE public synonym apps.XXEMPLOYEEDTLS FOR HR.XXEMPLOYEEDTLS;


EXEC AD_DD.REGISTER_TABLE('PER','XXEMPLOYEEDTLS','T',8,60,40);

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','EMPID',1,'NUMBER',20,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_NAME',2,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_LASTNAME',3,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_FIRST_NAME',4,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_JOIN_DATE',5,'DATE',38,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_POSITION',6,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_PROJECT',7,'VARCHAR2',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_HRA',8,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_TAX',9,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_PF',10,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_TOTALSALARY',11,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','E_PACKAGE',12,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','LAST_UPDATED_BY',13,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','LAST_UPDATE_LOGIN',14,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','CREATION_DATE',15,'DATE',38,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','CREATED_BY',16,'NUMBER',100,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','LAST_UPDATE_DATE',17,'DATE',38,'N','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE1',18,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE2',19,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE3',20,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN('PER','XXEMPLOYEEDTLS','ATTRIBUTE_CATEGORY',21,'VARCHAR2',100,'Y','N');

check table registration
NAVIGATION
application developer>>database>>table

query mode
enter your table name.