473,781 Members | 2,491 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

What is the best way to read data from oracle database and write it in a text file

17 New Member
Hi,

I want to know the best way to read bulk data (approx 1 lakh records) from database and write it into a text file, through c/c++/pro*c.

Thanks
Nishant Gaurav
Dec 7 '10 #1
0 1558

Sign in to post your reply or Sign up for a free account.

Similar topics

4
5802
by: Google Mike | last post by:
I have PHP version 4.2.2 that ships with RH9. I want to have it write to a file like this: function WriteLog($sLogFile, $sMsg) { if (substr($sLogFile,1,1) != '/') { $sLogFile = realpath(dirname($_SERVER)) . $sLogFile; } `echo "$sMsg" >> $sLogFile`;
2
9801
by: armin walland | last post by:
hi group! i am writing a small tool to dump data from oracle databases and i want to implement the possibility to execute sql statements read from stdin or from a file. i have so far managed to do so, but every sql statement must be on a single line with no ";" at the end of each line. i would like to use an input file like this:
1
2109
by: Twopair | last post by:
I have a problem DB:SQL Server Field type is varchar and some data is unicode like this "峯" It is a chinese. How do I transfer the data I retrive from DB and then I can write it into an text file with its proper chinese word using FileSystemObject Or any other way ?
14
2392
by: Manish | last post by:
The project I am developing doesn't involves database. I want to parse the mailbox file (.mbx) and store the summary in the text file for fast retrieval and display of information in the Inbox page. The sugegsted format are as: #1 ID : Subject : To Address: From Address...etc...
4
11049
by: Francois Stander | last post by:
Hi, hope someone can help me. It seems imposible to read data from a server, however, I can read the validation data from the server and hold it in dataviews . datasets or data tables in my asp "load" page. I would like to use these data (which I presume is in some form of html or xml) in my HTML portion of the asp page. The data must be read using java script and after lots of calculations perform on it - be written to xml controls. I can...
2
17487
by: asenthil | last post by:
Hai, i'm a beginner to java... just now i had tried to read and write files using java... and then i had tried to connect a database using jdbc... now i want to export the data's from a database into a text file
4
4415
by: sanparab | last post by:
I am a new user for MS Access 2003, I want to transfer a data of Fixed lenght text file into Access Tabel. The data is contained of four Record Set those are as follows 1. The header record type is ‘H’. 2. The detail record type is ‘D’. 3. The summary record type is ‘S’. 4. “END OF DOCUMENT” record is left justified with no record type. and the data is as follows
1
1508
by: nasir872 | last post by:
how to read from a csv or text file and write in another file ? please help. i need a working code example. thanks
6
1492
by: hermitking | last post by:
i need to read line 2 of a text file but not line 1 here is what i tryed Dim MyTime = Format(Now, "dd-MMM-yyyy") Dim phillstatus As String Dim phillcount As String Dim phillreader As String phillreader = My.Computer.FileSystem.ReadAllText("C:\Users\Richard\Documents\test.txt") phillcount = phillreader.ReadLine(1)
3
1533
JustRun
by: JustRun | last post by:
Hi all I'm trying to read some lines from a text file, and don't know how to do this. Actually I could read the whole file using object of StramReader, but to read custom line I think that I should use BeginRead() and EndRead() of FileStream class, but I dont know how to use them. I dont understand the parameters of them. If any one could explain, I'll be grateful. Thanks
0
9639
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9474
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10308
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10143
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8964
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5375
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5507
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3633
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2870
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.