Hi Ketan,

Ketan Madhak wrote:

I want to create region for each resulting row of select query on same page. Is it possible to create region dynamically for each row like that? i am using APEX 5.0,theme 25.

     Use the region type "PL/SQL Dynamic Content".

     Refer :

• Dynamic HTML Generated From PL/SQL Tutorial – APEX Blog
• plsql - Can you dynamically generate regions in Oracle APEX using PL/SQL? - Stack Overflow
• The Oracle APEX blog: Dynamically showing reports side by side

     Hope this helps!

Regards,

Kiran

Ketan Madhak wrote:

 

No it isn't a report region.In my case a user have a one or more addresses in address table.I want to display each address in different region.

If you really mean "display" (rather than "insert", "edit", or some combination thereof), then a report is the appropriate APEX solution. An APEX report is not a grid of rows and columns (which may be your only experience of them so far). It is a means of rendering the results of a SQL query as content in an HTML document. As a developer you are responsible for determining what structure and semantics is appropriate to that data, and converting that into the necessary HTML mark-up. In many cases a table of rows and columns is appropriate, and the report can be implemented using a built-in interactive report or classic report with a standard template. Where those do not meet the requirements, then a classic report with a custom template is used. These give the developer complete control over the report mark-up, enabling highly flexible and diverse layouts to be created. Here are some examples created as solutions to previous forum posts:

• Tabular report with subheadings (Issue with break formatting in Apex Classic Report with the third column.)
• Image with text overlay (is there a way to add text to the image automatically; CSS figcaption elements- not working)
• Multi-column list (Show Report In Two Columns)
• Dynamic matrix (Matrix report)
• Multiple dynamic report "regions" (Dynamic number of report regions)

These are all "reports", generating different HTML structures using custom templates, with different presentations achieved using CSS. They demonstrate that reports are the best way to display read-only information in APEX. (Reports can be used to generate complex forms, but this will usually require custom processing to be developed to handle the submitted data. It's generally therefore better to use the standard APEX "form on a table with report" design pattern, customising the report to meet any complex layout requirements, and utilise default APEX forms for data entry and maintenance. This is particularly effective in APEX 5.0 where the form page can be created as a pop-up dialog with no extra effort.)

Provide detailed requirements, then we can decide if the solution is a report or something else.