10.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 10-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 6-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