List Contents of Directory in Autonomous Database
Use the function DBMS_CLOUD.LIST_FILES to list the contents of a
directory.
For example, to list the contents of the staging directory,
run the following query:
SELECT * FROM DBMS_CLOUD.LIST_FILES('STAGING');To run DBMS_CLOUD.LIST_FILES with a
user other than ADMIN you need to grant read privileges on the directory to that user. See
LIST_FILES Function
for more information.
Parent topic: Creating and Managing Directories on Autonomous Database