| Populate Collections to show a column's values into Column headings in Oracle APEX tabular form/IG [message #666401] |
Thu, 02 November 2017 11:02  |
 |
srinuvaasreddy@gmail.com
Messages: 1
Registered: November 2017
|
Junior Member |
|
|
Hi all,
1. I have a requirement to create a new Interactive grid/tabular form. In Oracle db, I have a table A with a column A_ID and I have another table B with columns B_ID, B_NAME. By joining these 2 tables, I can bring B_NAME. I came up with 10 records on B_NAME and I want to show the B_NAME column values as column heading in Oracle APEX 5.1 Tabular form/IG. For this, I have to use collections.
2. I have a different table C with C_ID, and C_VALUES. By joining B & C tables, I come up to certain C_VALUES to each B_NAME. For each B_NAME value, I brought certain C_VALUES. Now, I want to use collections to convert B table B_NAME values into columns as COLUMN HEADINGS and For each B_NAME column heading in APEX, I want to show the list of values (as select list) under each field. The entire form needs to be build dynamically and I want to use a couple or more collections to achieve this. I am pretty new to Oracle APEX and I do not have any idea how to achieve this entire thing. Please share your thoughts on this.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
