Online Documentation for SQL Manager for Oracle
Export as SQL Script Wizard
Export as SQL Script wizard allows you to export data from a table / view or from a query result to Execute Script as a number of INSERT statements. You can save your settings as a template any time for future use.
To start the wizard, right-click the object in DB Explorer, select the Data Manipulation | Export Data as SQL Script...context menu item.
Alternatively, you can open the Data tab of Table Editor / View Editor or the Result(s) tab of Query Data / Design Query, right-click the grid there, then select the Data Manipulation | Export <object_name> as SQL Script... context menu item.
- Selecting destination DBMS
- Setting destination file name
- Setting BLOB options
- Selecting field to export
- Editing the result table definition
- Setting export options
- Exporting as Execute Script
Availability: |
|
Full version (for Windows) |
Yes |
Lite version (for Windows) |
No |
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |