Users would sometimes want to know how many tables are existing in their account. On the documented list of tables, there is no specific table that contains this information.
By using Microsoft Excel, it is possible to retrieve this information using the System Tables > OA_TABLES.
Using Microsoft Excel
1. Navigate to Data > Import External Data > New Database Query and choose Data Source
2. Enter username and password
3. Check System Tables
4. Select OA_TABLES
5. Continue by clicking 'Next" until the data is imported to Excel
6. The data will return all the tables in your account
No comments:
Post a Comment