Export a table to csv or text file with Column headers

[booker@mgt]

How do you export a table to include not only the table data but the header
row information as well

I need to import data from one database to another network database, but I
need the header row information so that I can do field mapping?

Thanks

 

[pietlinden]

How do you export a table to include not only  the table data but the header
row information as well

I need to import data from one database to another network database, but I
need the header row information so that I can do field mapping?

Thanks

Can you not connect directly and export/import? What if you at least
temporarily attach the source/destination table and create an append
query? if you do that, you can save the Export/Import specification
(click on Advanced when you're running the export setup).

 

[booker@mgt]

No, there are too many hoops to jump through. One database is in one
company, one one network

The destination database is on a third party database on another network,
and b/c of red tape/beuracracry, etc ,etc, I can't get the two sides to allow
access to each others networks.

So it was mentioned to get a pipe delimited or some type of delimited
csv/text file that could be used to import the data... but like i said, when
I try it with access, i just get the data

When i use pl/sql to connect to the oracle database and issue commands to
create a file, I get the same thing... data with no header row