FREEWARE: Export Insert Statements from Datagrid

Ok Glenn-

Here is the prior Freeware version, updated with a November expiration which
should be well past the fall 10.6 Freeware update:

http://toadsoft.com/old_freeware/freeware_update.zip

the installer link:

http://toadsoft.com/old_freeware/toadfree.zip

Look at these three screen snapshots.

#1 – start a SQL*Plus session from my Windows PC

#2 – perform a ps –ef command on the Linux server – note PID =
7256 (if this was the big problem top would show this guy near top)

#3 – Session Browser – note the SPID for 7256 – it shows that
it’s my SQL*Plus session – and I could look at the bottom current
statement tb to see what command it’s running – and if it’s a
long running op – then that bottom tab would show percent complete
….

Look at these three screen snapshots.

#1 – start a SQL*Plus session from my Windows PC

#2 – perform a ps –ef command on the Linux server – note PID =
7256 (if this was the big problem top would show this guy near top)

#3 – Session Browser – note the SPID for 7256 – it shows that
it’s my SQL*Plus session – and I could look at the bottom current
statement tb to see what command it’s running – and if it’s a
long running op – then that bottom tab would show percent complete
….

Thanks Mark, that’s got me out of hot water. :slight_smile:

Hopefully anyone else who finds the same issue with the latest freeware will hunt down the link too.

Now that I can see the previous version again, I can assist with passing on more info about what export formats were missed in the latest version.

If I do a “Grid->Save As” I can see that there were 8 different formats available for exporting the data in the grid. They were:

  • Delimited Text
  • Fixed Field Spacing
  • HTML Table
  • Insert Statements
  • SQL Loader
  • XLS File
  • XLS Instance
  • XML (plain)

Selecting each format would present different additional options for how to format the exported data. Eg. When exporting INSERT statements, there were fields to specify the “Insert Schema” and “Insert Table” and an Auto button to fill these in for you.

I hope that’s useful info.

Well that’s it from me for now, so once again thanks very much for attending to the issue and making a workaround available.

All the best,
Glenn

SEE ATTACHMENT

SEE ATTACHMENT

ok Glenn, this will be fixed for the 10.6 fall freeware release

ok Glenn, this will be fixed for the 10.6 fall freeware release

ok Glenn, this will be fixed for the 10.6 fall freeware release

That's great news, thanks. For now, I'm coping nicely with the prior version you made available.

Regards,
Glenn