Re: Generating Huge Table

as (none_at_asgmeail.com) wrote:

: "Frank van Bortel" <frank.van.bortel_at_gmail.com> ???
: news:d6spvg$ar3$1_at_news6.zwoll1.ov.home.nl ???...
: > Sounds like an *excellent* case for the merge
: > statement.
: > And Thomas Kyte has some benchmarks on insert... exception
: > vs merge (also on insert/update vs update/insert).
: >
: > I would call this a prime example of something you
: > do *not* want to do in Java.
: >
: > --
: > Regards,
: > Frank van Bortel

: Another concern is MERGE expects a *TABLE* of rows to be merged into the
: target table. But the point is my java program generates 1 *ROW* at a time.
: How should I utilitised the MERGE statement? Is it by creating a temporary
: table an do a MERGE for, say, every 10 rows generated?

I though you said

	"I am using JDBC to access Oracle from Java program.  I need to
	generate a huge table from reading a another huge input table.
	Here is the requirement:

	1. Read a row from the input table, do calculation, generate a
	target row.

so surely you do have an input table.

--

This space not for rent.