Hi,
bladepit wrote:
I can't post the table definition
Don't be silly. Of course you can post CREATE TABLE and INSERT statmenents for some sample data. They don't need to have the same names as your real tables and columns, any more than they need to have the same size or the same data as your real tables.
If you can show what you need to do using commonly available tables, such as those in the scott or hr schemas, then you don't need to post any tables of your own. But one way or another, you have to provide sample data to the people who want to help you.
or something else but i hope i can explain my table. I thought this select will make it little bit clearer:
select value, ref, bez from table where (bez = 'A' OR bez = 'B') and ref in (200,201,202....) order by ref;
The value is the important information here. The output could be something like that:
value ref bez
0,0251;194;A
0,7063;194;B
1,2265;195;B
0,7063;198;B
Over the amount of the two sets i want to calculate the pearson.
What are the results you would want from this small sample data set?
I'm sorry I don't know much about your application, or about statistics. This is a SQL and PL/SQL forum. If you happen to find someone here that knows all about your application and about statistics, that's great, but in general, you'll have to explain what you want. With your knowledge of your application and of statistics, and our knowlege of SQL, I'm confident we (the poeple on this forum) can solve this problem, if we work together.
I think if i put them into an tmptable in my database and execute this sql statement:
select CORR(x,y) from tmptable;
i will get my information but i need to do that for more then 2 million different bez
What is a bez? Why is the number of different bez singnificant in this problem?
and i think this will not be very efficient.
Where is the data now?
If it's not in an Oracle database, or someplace that can be read from Oracle, why are you even considering using an Oracle function?
Given that you do want to use an Oracle function, then you have to get the data into Oracle, even if that takes time.