Skip to Main Content

SQL Developer

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!

pass table name to report dynamically?

berxApr 25 2012 — edited Apr 27 2012
I am searching for any method to pass any table name to a sql statement in a self-written report.

a short example:
I try to create a report which lets me select a column from a table - both (column and table) should be provided at time the report is executed.
Of course something like
select :column
from :table
does not work; error is ORA-01745.

Does anyone knows a method to pass a variable string into the SQL before the cursor is created?
This post has been answered by thatJeffSmith-Oracle on Apr 27 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2012
Added on Apr 25 2012
7 comments
1,050 views