Pablo

South Korea

11h
awarded Popular Question
19h
comment How to fetch and show data from multiple tables into Report?
One more excellent answer!
19h
accepted How to fetch and show data from multiple tables into Report?
1d
awarded Yearling
1d
comment How to retrieve and use row(s) from database in HTML page?
That works like a charm, although I used something like i.text_col inside loop. Thanks again!
1d
accepted How to retrieve and use row(s) from database in HTML page?
1d
comment How to retrieve and use row(s) from database in HTML page?
Dmitry, as always thanks for prompt response. Could you please bring an example how I store and reference records? Do I have to store query result into some collection(using SELECT/INSERT?), then use some syntax to access each record from htp.p? Just so I go in the right direction.
1d
revised How to retrieve and use row(s) from database in HTML page?
added 43 characters in body
1d
asked How to retrieve and use row(s) from database in HTML page?
2d
awarded Yearling
2d
comment How to fetch and show data from multiple tables into Report?
I figured out that it's impossible to create more than one interactive regions in single page. So question number one would be "any type, which will provide link to another page, where I can edit data"
2d
comment How to fetch and show data from multiple tables into Report?
Dmitry, 1) Interactive Report region 2) Editing on another page
2d
asked How to fetch and show data from multiple tables into Report?
2d
accepted How to duplicate a table with constraints, indexes, etc. in APEX?
2d
accepted How to bind multiple tables to single DM form?
2d
comment How to duplicate a table with constraints, indexes, etc. in APEX?
in place of what? could you please bring example on how to use this? Would it take care of triggers and sequences associated with that table?
2d
comment How to duplicate a table with constraints, indexes, etc. in APEX?
Looking at SQL metadata of table, I see there is associate trigger and sequence. I assume this would work, but is there better way, in case a table has more such dependencies?
2d
comment How to duplicate a table with constraints, indexes, etc. in APEX?
There is SQL workshop -> SQL commands, where I suppose it's possible to write queries. I can give it a try.
2d
asked How to duplicate a table with constraints, indexes, etc. in APEX?
2d
comment How to bind multiple tables to single DM form?
Yes, it doesn't look like view allows update original tables...
1 2 3 4 5