Export all tables of one user including CLOB columns as INSERT statements
Dear community,
I need to export all tables of one user including CLOB columns as INSERT statements because I need all data only (vs schema). How do I do it? What is the best automatic, easy to go approach here?
Select * from one table, right click on the Query Results pane and select Export... (Inserts) does not include the CLOB fields (see here).
Thanks!