Re: No Dynamic SQL in Function or Trigger Frustration
> 1. How difficult is it to re-write a local version of MySQL from source to actually permit this feature to function?
Very, even if you're an accomplioshed C++ programmer.
> To jump between C, C#, VB, PHP, Python or anything else to do this would increase runtime to anywhere in the #Nth millions of years to run til completion
What's the point of such hyperbole? Developers implement calculations of the sort you describe every day in app languages like PHP.
> The base tables for my query applies a combination of tables. 4 to be precise, using 5 columns in each to set 20 possible values.
> For each string of 20 I intend to account for spreads and statistical offsets between the various numbers when applied as a matrice [sic]
SQL is set-based, so it isn't an optimal tool for large-matrix calculations like that. Are you sure you shouldn't be using something like R?
Subject
Views
Written By
Posted
2776
February 27, 2014 06:47PM
1159
February 27, 2014 08:47PM
1126
February 27, 2014 09:11PM
Re: No Dynamic SQL in Function or Trigger Frustration
1098
March 14, 2014 07:43PM
1224
March 15, 2014 02:26AM
1072
March 15, 2014 10:47AM
1056
March 17, 2014 12:29AM
1040
March 17, 2014 10:38PM
1202
March 18, 2014 04:13PM
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.