13.3.2 ALL_PYQ_DATASTORES View

The ALL_PYQ_DATASTORES view contains information about the datastores that are available to the current user.

Column Datatype Null Description
DSOWNER VARCHAR2(256) NULL permitted The owner of the datastore.
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-2 Selecting from the ALL_PYQ_DATASTORES View

This example selects all columns from the ALL_PYQ_DATASTORES view. It then selects only the DSNAME and GRANTABLE columns from the view. For the creation of the datastores in these examples, see Example 7-14. 

SELECT * FROM ALL_PYQ_DATASTORES;

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

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

SELECT DSNAME, GRANTABLE FROM ALL_PYQ_DATASTORES;

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

Parent topic: Datastores Supporting Embedded Python Execution