APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

access tables via database name and table name

apexStarterJun 14 2011 — edited Jun 16 2011

Hi all

i want to make a query on table like

select * from <database_name>.<table_name>

now i have database_name and table_name in items on a page like p3_database and p3_table

but this form of query isn't working out

select * from :p3_database.:p3_table

any suggestions please

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2011

Added on Jun 14 2011

#apex, #apex-discussions, #database, #dynamic, #report, #schema, #table

12 comments

724 views