Team,
Can you please share the script TOAD uses to generate the script of each tables in the schema browser?
Regards,
Stanis
Team,
Can you please share the script TOAD uses to generate the script of each tables in the schema browser?
Regards,
Stanis
Toad doesn’t just run queries that produce a script as an output. We run a bunch of queries, (which you can see by clicking Database -> Spool -> Spool SQL), but then we build the script internally using the results of the queries.
If you want a “script to build a script”, do a google search on dbms_metadata.get_ddl.