13.3.1 ALL_PYQ_DATASTORE_CONTENTS View

The ALL_PYQ_DATASTORE_CONTENTS view contains information about the contents of datastores that are available to the current user.

Column Datatype Null Description
DSOWNER VARCHAR2(128) NULL permitted The owner of the datastore.
DSNAME VARCHAR2(128) NULL permitted The name of the datastore.
OBJNAME VARCHAR2(128) NULL permitted The name of an object in the datastore.
CLASS VARCHAR2(128) NULL permitted The class of a Python object in the datastore.
OBJSIZE NUMBER NULL permitted The size of an object in the datastore.
LENGTH NUMBER NULL permitted The length of an object in the datastore. The length is 1 for all objects unless the object is a list, dict, pandas.DataFrame, or oml.DataFrame, in which case it is equal to len(obj).
NROW NUMBER NULL permitted The number of rows of an object in the datastore. The number is 1 for all objects except for pandas.DataFrame and oml.DataFrame objects, in which case it is equal to len(df).
NCOL NUMBER NULL permitted The number of columns of an object in the datastore. The number is len(obj) if the object is a list or dict, len(obj.columns) if the object is a pandas.DataFrame or oml.DataFrame, and 1 otherwise.

Example 13-1 Selecting from the ALL_PYQ_DATASTORE_CONTENTS View

This example selects all columns from the ALL_PYQ_DATASTORE_CONTENTS view. For the creation of the datastores in this example, see Example 7-14. 

SELECT * FROM ALL_PYQ_DATASTORE_CONTENTS

DSOWNER   DSNAME        OBJNAME       CLASS              OBJSIZE  LENGTH  NROW  NCOL
--------  ------------  ------------  -----------------  -------  ------  ----  ----
OML_USER  ds_pydata     oml_boston    oml.DataFrame         1073     506   506    14
OML_USER  ds_pydata     oml_diabetes  oml.DataFrame          964     442   442    11
OML_USER  ds_pydata     wine          Bunch                24177       5     1     5
OML_USER  ds_pymodel    regr1         LinearRegression       706       1     1     1
OML_USER  ds_pymodel    regr2         oml.glm               5664       1     1     1
OML_USER  ds_wine_data  oml_wine      oml.DataFrame	  1410     178   178    14

Parent topic: Datastores Supporting Embedded Python Execution