This discussion is archived
2 Replies Latest reply: Jan 5, 2013 5:20 AM by K_Serge RSS

SQL Dev Child Reports - Dynamic From Clause Possible?

569930 Newbie
Currently Being Moderated
Hi All,

Trying to figure out this problem:

Master Report SQL:

select TABLE_NAME from USER_TAB_COLS where COLUMN_NAME = 'CREATION_DATE'

Results with some table names. Now I want to use the table name to formulate my child query

Child SQL:

select * from :TABLE_NAME where CREATION_DATE >= SYSDATE-7

or whatever.....but I want to somehow use the table_name dynamically.

Thanks!
-Brent

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points