|
View unanswered posts | View active topics
  |
Page 1 of 1
|
[ 2 posts ] |
|
| Author |
Message |
|
selvamps
Joined: Mon Jun 09, 2008 3:45 pm
Posts: 54
Location: Chennai
|
 ALL_TAB_COLS Though both ALL_TAB_COLS and FND_COLUMNS deals with the Columns of the Table, what are the differences between them?
|
| Mon Jul 07, 2008 10:26 pm |
  |
 |
|
Pradeep
Joined: Sat Jun 07, 2008 11:06 pm
Posts: 54
---------
|
Re: ALL_TAB_COLS They are almost the same but the major difference between them is that ALL_TAB_COLS will have all the columns of the tables which are created in the database and supposedly is owned by APPLSYS but the FND_COLUMNS is a table which holds the names of the columns of those tables which are registered in APPS using the package AD_DD.Register_Column and is owned by APPS.
If a column is not registered using AD_DD then its columns will not reflect in FND_Columns whereas whenever a table is created in the database, its columns will reflect definitely in ALL_TAB_COLS.
Hope this helps.
|
| Tue Jul 08, 2008 9:43 pm |
|
|
|
|
Page 1 of 1
|
[ 2 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 0 guests |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
|
