How to export data from Oracle to an SQL script

Method 1:

You must use the PL/SQL Dev tool.
1. Open PL/SQL Dev and select the table to be exported. Right-click the table and select export data from the pop-up menu, as shown in ).
 
2. After you click Export data, the export settings window appears on the right, as shown in:
 
Under the window, select the SQL inserts tab and set the export conditions.
3. Click the export button to export the data.

Method 2:

You have to write the program yourself and execute an SQL statement to make the SQL query result the SQL script we want:

As follows:

Select
'Insert into B _stattemplate (n_id, c_name, c_kbh, n_print, n_type, n_app, n_valid )'
| 'Values ('| to_char (n_id) |', ''' | c_name | ''', ''' | c_kbh | ''','
| To_char (n_print) | ',' | to_char (n_type) | ',' | '0, 0 );'
From B _stattemplate

Save the query results!

 

Who has the third method?