The PROC SQL SELECT statement uses a CONNECTION TO component in the FROM clause to retrieve data from the ORACLE table. The Pass-Through query (in italics) is enclosed in parentheses and uses ORACLE ...

The remaining patches covered a wide variety of Oracle products. The information Oracle released with its critical patch update, its quarterly patching method, was, as usual, limited.

I'd also advocate for it if there is a reason this query would ever change, as having it in a sproc would decouple those changes from the application (i.e. update the database without having to ...