progress 4gl - What is the easiest way to 'dump' a temp-table into SQL format -

progress 4gl - What is the easiest way to 'dump' a temp-table into SQL format -

version: 10.2b

so lets have table dogs in progress:

table: dogs fields: name, age, breed

i want load them oracle database using standard load utility. table in oracle looks this

table: dog fields: name, age, date_last_updated

so if create temp-table matching this, there way 'dump' temp table sql? (so can load oracle)

if not, fine reply too.

thanks help!!

edit: 'sql dump' mean:

insert dog values (max, 5, feb 18, 2013)

is there way table in format other exporting words "insert into" file.

using database management tool odbc back upwards (dbeaver example) can connect progress databases , export tables , views sql inserts.

progress-4gl openedge