Register Tables and Columns in ORACL APPS

Create table taking required columns USING CREATE TABLE STATEMENT

1.Pass the following paramter to the  below procedure for register a new table

 Procedure REGISTER_TABLE( p_appl_short_name in varchar2,
    p_tab_name in varchar2,
    p_tab_type in varchar2,
    p_next_extent in number default 512,
    p_pct_free in number default 10,
    p_pct_used in number default 70);
  
  
    EXAMPLE
  
    BEGIN
AD_DD.REGISTER_TABLE ('FND','TABLE_NAME','T');
END;

2.Pass the following paramter to the  below procedure for register columns of a table

Procedure REGISTER_COLUMN(p_appl_short_name in varchar2,
    p_tab_name in varchar2,
    p_col_name in varchar2,
    p_col_seq in number,
    p_col_type in varchar2,
    p_col_width in number,
    p_nullable in varchar2,
    p_translate in varchar2,
    p_precision in number default null,
    p_scale in number default null);
  
EXAMPLE
  
BEGIN
AD_DD.REGISTER_COLUMN ('FND', 'TABLE_NAME','COLUMN_NAME', 1, 'VARCHAR2', 150, 'Y', 'N');
END;
  
  
Finally check in below query,whether it is registerd or not!!!


SELECT * FROM FND_TABLES  
WHERE TABLE_NAME LIKE'TABLE_NAME'