10.3.5 USER_PYQ_SCRIPTS View

This view contains information about the user-defined Python functions in the OML4Py script repository that are owned by the current user.

Column	Datatype	Null	Description
NAME	VARCHAR2(128)	NOT NULL	The name of the user-defined Python function.
SCRIPT	CLOB	NULL permitted	The user-defined Python function.

Example 10-5 Selecting from the USER_PYQ_SCRIPTS View

This example selects all columns from USER_PYQ_SCRIPTS.

SELECT * FROM USER_PYQ_SCRIPTS;

NAME                SCRIPT
-----------------   -------------------------------------------------------------------
create_iris_table   "def create_iris_table():    from sklearn.datasets import load_iris ...
tmpqfun2            "def return_frame():     import numpy as np       import pickle     ...