Posted
by R K
on Stack Overflow
See other posts from Stack Overflow
or by R K
Published on 2010-04-08T05:59:40Z
Indexed on
2010/04/08
6:03 UTC
Read the original article
Hit count: 559
What to use in oracle 10G to extract 6 million records and create a flat file of it ?
© Stack Overflow or respective owner
as seen on Server Fault
- Search for 'Server Fault'
I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. The CPU on the oracle server skyrockets for long periods of time, and it seems like the optimizer…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I just want to give you a little background
Need to write a PL-SQL which will extract 6 million record joining different tables and create a file of that.
Need more suggestions, specifically on how to fetch these many records. As fetching these million of records on a single go can be a highly resource…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
What to use in oracle 10G to extract 6 million records and create a flat file of it ?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi guys,i want to know how can we know the other users of oracle 10g on the same system.
Is there any querry for that?
thank you!!!
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am looking for a newer version of the Pro*C/C++ to upgrade my procui.exe 9.0.1.1.1.
I downloaded the 10g client disk and when install I have the following options:
instant client
administrator
runtime
custom
I dont seem to able to find the actual program other than just getting some…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have the following structure:
MyClass {
guid ID
guid ParentID
string Name
}
I'd like to create an array which contains the elements in the order they should be displayed in a hierarchy (e.g. according to their "left" values), as well as a hash which maps the guid to the indentation level…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have the following flat tree:
id name parent_id is_directory
===========================================================
50 app 0 1
31 controllers 50 1
11 application_controller.rb 31 …
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a process that currently runs in a Delphi application that I wrote and I need to convert it to a Java process that will run on our web application. Basically our State Financial (legacy) system requires this file in a specific output. In Delphi it is like this:
procedure CreateSHAREJournalFile(AppDate…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Falling equipment prices will offset substantial increases in VoIP subscription rates.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
But research firm sees tremendous upside in 2010. Where will it come from?
>>> More
