Call DirList() to display the contents of a directory. Use Filter= to prune the returned results:

 

1 SQL> call DirList(Directory=:v_my_dir, Filter=‘*.csv’);

 

In these results, we see that there is one CSV file in our directory, the one we just created.