13.4.2 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 13-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 ...