List of Contributions

Contact Details

University of California-Santa Cruz

Ribbons

Badges

Erica Simpkins

University of California-Santa Cruz

Contributions

1 to 1 of 1 total

RE: Reporting out Run Control Values for a User

Posted By Erica Simpkins 03-16-2026 09:27 AM
Found In Egroup: PS Query & SQL \ view thread

What Jeffrie said. You can even build your main query to return your SQL for the individual queries. select distinct 'select * from ' || A.table_name || ' where OPRID = :1;' from all_tab_columns A, all_tab_columns B where A.table_name = B.table_name and A.column_name = 'OPRID' and B.column_name ...