procedure for matrix multiplication
I am new to SQL programming but have worked with time series processing packages for the last few decades.
For reasons too strange to get into, I need to use SQL to create a stored procedure that I can call to multiply the data in two tables to create data for a third table. Table1 has data of dimensions PxQ, Table2 of QxR, and I want to create data for a new Table3 of dimensions PxR (i.e. matrix multiplication of Table1 and Table2).
I will need to use this procedure repeatedly so I would like to be able to call it and supply it with arguments for the table names.
I believe this is possible in SQL, but have not been able to get anything to work yet. Any assistance will be appreciated.
Subject
Views
Written By
Posted
procedure for matrix multiplication
5119
August 04, 2016 05:37PM
1060
August 04, 2016 05:49PM
949
August 04, 2016 08:09PM
1609
August 11, 2016 06:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.