US Patent Issued to Oracle International on June 17 for "Method and system to implement SQL macros" (California Inventors)

ALEXANDRIA, Va., June 19 -- United States Patent no. 12,332,893, issued on June 17, was assigned to Oracle International Corp. (Redwood Shores, Calif.).

"Method and system to implement SQL macros" was invented by Atif Chaudhry (Fremont, Calif.), Chandrasekharan Iyer (Redwood City, Calif.), Lei Sheng (Redwood City, Calif.) and Agrawal Shashaanka (Hayward, Calif.).

According to the abstract* released by the U.S. Patent & Trademark Office: "Disclosed is an approach to define non-SQL functions as a SQL macro, which is then processed inline with SQL statements. By inlining the macro into SQL, this approach avoids cross-engine context switches as well as making it possible for a SQL query optimizer to generate better plans that execute more eff...