How to Register Table in Oracle Apps
Step 1:- Create table in Apps Schema.
Create Table XXC05_TEST_TAB(ID
NUMBER(6), FNAME VARCHAR2(20));
Setp 2:- Execute below code.
A)- EXECUTE AD_DD.REGISTER_TABLE('SQLGL','XXC05_TEST_TABLE','T',8,10,90);
B)- EXECUTE AD_DD.REGISTER_COLUMN('SQLGL','XXC05_TEST_TABLE','ID',1,'NUMBER'V,6,'N','N');
C)- EXECUTE AD_DD.REGISTER_COLUMN('SQLGL','XXC05_TEST_TABLE','FNAME',2,'VARCHAR2',20,'N','N');
A)- EXECUTE AD_DD.REGISTER_TABLE('SQLGL','XXC05_TEST_TABLE','T',8,10,90);
B)- EXECUTE AD_DD.REGISTER_COLUMN('SQLGL','XXC05_TEST_TABLE','ID',1,'NUMBER'V,6,'N','N');
C)- EXECUTE AD_DD.REGISTER_COLUMN('SQLGL','XXC05_TEST_TABLE','FNAME',2,'VARCHAR2',20,'N','N');
Now See In Front End
Application Developer -> Database
-> Table
Query in Table XXC05_TEST_TAB;
No comments:
Post a Comment