Any Suggestions to what pl-sql to use to extract huge volume of records (Six million) from Oracle 10G database taking a join from multiple tables ? | ansaurus

tags:

views:

40

answers:

1

+1 Q:

Any Suggestions to what pl-sql to use to extract huge volume of records (Six million) from Oracle 10G database taking a join from multiple tables ?

Possible Duplicate:
Any suggestions on how to extract 6 million records from an oracle10g ?

Any Sample pl-sql code on the same will be highly appreciated.

+1 A:

Hummm... SELECT?

Paulo Santos 2010-04-11 17:01:57

related questions

Is there a Way to use Linq to Oracle

NHibernate and Oracle connect through Windows Authenication

Boolean Field in Oracle

How do you manage schema upgrades to a production database?

How do I deal with quotes ' in SQL

When do you use table clusters?

Oracle write to file

MS SQL Server 2008 "linked server" to Oracle : schema not showing

Develop on local Oracle instance

Resources for an Oracle beginner

What strategies have you employed to improve web application performance?

Automate Syncing Oracle Tables With MySQL Tables

Best way to encapsulate complex Oracle PL/SQL cursor logic as a view?

What Content Management does your workplace use?

What is the difference between oracle's 'yy' and 'rr' date mask?

SQL/Query tools?

How to make Pro*C cope with #warning directives?

Oracle SQL Developer not responsive when trying to view tables (or suggest an Oracle Mac client)

How big would such a database be?

Oracle - What TNS Names file am I using?

What is a good way to open large files across a WAN?

How do I find the high water mark (for sessions) on Oracle 9i

SQL Case Statement Syntax?

cx_Oracle - what is the best way to iterate over a result set?

cx_Oracle - How do I access Oracle from Python?