I need some help in exporting a schema. I want to use the query parameter in the exp command. My query looks something like:
select * from cat where id in
(select child_cat_id
from cat_rel
connect by parent_cat_id = prior child_cat_id
start with parent_cat_id in (select cat_id from store_root_cat where store_id = 14))
I need to bring in all the records from the tables that match this query. I need other tables too. How do I do this?
Thanks,
Nirasha