Re: new to oracle...HELP!

You can export data in an Oracle binary format using EXP utility but there is no such command to export data tables to flat files.

Fortunately you can write a script in SQL Plus to do that.

My freeware utility SQLPlusPlus allows you to create such a script without any knowlege of SQLPlus etc by just using EXEC S.BLDDAT (tablename).

You can then modify this script to use whatever delimiter you want to use before executing it in sql plus.

regards,
M. Armaghan Saqib

• SQL PlusPlus : Add power to SQL Plus command line
• SQL Link for XL : Integrate Oracle with XL
• Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

  ---

  <sayoni_at_my-deja.com> wrote in message news:84uhbs$4qf$1_at_nnrp1.deja.com...
  > hi gurus,
  > coming from a sybase background i am at a loss trying to figure out a
  > way to export data to a file. I was wondering if there is any way to
  > provide a column and a row delimiter when exporting the data out from
  a
  > table into the file. any help much appreciated.
  > tia.
  > sayoni
  >
  >
  > Sent via Deja.com http://www.deja.com/
  > Before you buy.
  

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 05 2000 - 00:31:50 CST