13.3.3 USER_PYQ_DATASTORES View

The USER_PYQ_DATASTORES view contains information about the datastores that are owned by the current user.

Column Datatype Null Description
DSNAME VARCHAR2(128) NULL permitted The name of the datastore.
NOBJ NUMBER NULL permitted The number of objects in the datastore.
DSSIZE NUMBER NULL permitted The size of the datastore.
CDATE DATE NULL permitted The date on which the datastore was created.
DESCRIPTION VARCHAR2(2000) NULL permitted A description of the datastore.
GRANTABLE VARCHAR2(1) NULL permitted Whether or not the read privilege to the datastore may be granted. The value in this column is either T for True or F for False.

Example 13-3 Selecting from the USER_PYQ_DATASTORES View

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

SELECT * FROM USER_PYQ_DATASTORES;

DSNAME       NOBJ   DSSIZE   CDATE       DESCRIPTION       G
----------   ----   ------   ---------   ---------------   -
ds_wine_data    1     1410   18-MAY-19   wine dataset      F
ds_pydata       3    26214   18-MAY-19   python datasets   F
ds_pymodel      2     6370   18-MAY-19                     T

This example selects only the DSNAME and GRANTABLE columns from the view.

SELECT DSNAME, GRANTABLE FROM USER_PYQ_DATASTORES;

DSNAME        G
----------    -
ds_wine_data  F
ds_pydata     F
ds_pymodel    T

Parent topic: Datastores Supporting Embedded Python Execution