Use the ReadFile() table function to query a CSV file as a Connect table. Use SELECT as you would with a regular database table:

1 SQL> select * from ReadFile(FilePath=‘{:v_my_dir}periods.csv’, Separator=‘|’, Quote=‘”‘, FirstLineNames=true);