Merge Data Sets

Hi,
Does anyone have any experience with merging two data sets that have no relationship whatsoever. for example.

Table X ( Acol varchar2,Bcol varchar2,dob date)

Table Y (XCol Number)

|
|
        

Table Z (XCol number, Acol varchar2,Bcol varchar2,dob date)

these table have no join key and thier is around 25 million rows..

any help would be appreciate, I have written a bit of pl/sql but it is miserably slow, i am wanting to take advantage of direct insert hint.

many thanks

andre Received on Tue Sep 25 2001 - 10:11:49 CDT