Example 13-4 Selecting from the ALL_PYQ_SCRIPTS View

This example selects the owner and the name of the user-defined Python function from the ALL_PYQ_SCRIPTS view.

SELECT owner, name FROM ALL_PYQ_SCRIPTS;

OWNER      NAME
--------   -----------------
OML_USER   create_iris_table
OML_USER   tmpqfun2
PYQSYS     tmpqfun2

This example selects the name of the user-defined Python function and the function definition from the view.

SELECT name, script FROM ALL_PYQ_SCRIPTS WHERE name = 'create_iris_table';

NAME                SCRIPT
-----------------   ---------------------------------------------------------------------
create_iris_table   "def create_iris_table():  from sklearn.datasets import load_iris ...