Home » SQL & PL/SQL » SQL & PL/SQL » Procedure to convert the sql output or cursor to dbf file (oracle 10gr2)
Procedure to convert the sql output or cursor to dbf file [message #442432] Mon, 08 February 2010 00:40 Go to next message
pradeep2002gs
Messages: 19
Registered: August 2009
Junior Member
hi folks,

i need to convert the given query output to .dbf file. i know how to convert it to a .xls file but i'm unable to make it as .dbf file.

The application takes the input as dbf file alone and i'm restricted to use sql and pl/sql alone.

Thanks in advance.
Re: Procedure to convert the sql output or cursor to dbf file [message #442436 is a reply to message #442432] Mon, 08 February 2010 01:06 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
rename the .xls to .dbf
Seriously though, "a .dbf file" defines nothing about the format of the contents. There are multiple database vendors who use(d) this extension. (dBase and FoxPro to mention just two. Abacus also used this extension).
Re: Procedure to convert the sql output or cursor to dbf file [message #442437 is a reply to message #442436] Mon, 08 February 2010 01:08 Go to previous messageGo to next message
pradeep2002gs
Messages: 19
Registered: August 2009
Junior Member
i have check it but it is not working dbf has some format which xls dont. it defines the width and field type.
Re: Procedure to convert the sql output or cursor to dbf file [message #442443 is a reply to message #442437] Mon, 08 February 2010 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is definitively neither a SQL nor an Oracle question.

Regards
Michel
Re: Procedure to convert the sql output or cursor to dbf file [message #442454 is a reply to message #442437] Mon, 08 February 2010 04:07 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
pradeep2002gs wrote on Mon, 08 February 2010 08:08
i have check it but it is not working dbf has some format which xls dont. it defines the width and field type.

Did you bother to read past the first line of my post?
Previous Topic: Bad running queries
Next Topic: SQL query
Goto Forum:
  


Current Time: Wed Sep 28 14:21:25 CDT 2016

Total time taken to generate the page: 0.08074 seconds