I was trying to get an select * from (for column table result) every table_name with the result bellow, how can i achieve this?
(SELECT a.table_name FROM all_cons_columns a JOIN all_constraints c ON a.owner = c.owner AND a.constraint_name = c.constraint_name JOIN all_constraints c_pk ON c.r_owner = c_pk.owner AND c.r_constraint_name = c_pk.constraint_name WHERE c.constraint_type = 'R' AND c_pk.table_name = 'MY_TABLE_NAME')
suppose that the result above was:
i want to return an select * from (only one row of that table)every one of those tables listed. Beware i cannot use variable, or any other thing related to PL/SQL, so only SQL.
Sorry for my bad english. I hope it was clear. Thank you anyone in advance.