Skip to Main Content

CSV file from stored queries

User_70275Mar 16 2021

Hi, I have table with a lot of queries stored as a clob data.
So it looks like
create table z_queries (QUERY_NAME VARCHAR2(50 CHAR),
QUERY CLOB,
CSV_GEN VARCHAR2(1 BYTE))
I need to generate csv file with results of every query which has status csv_gen='Y'. Can anyone tell me how can i do that? This could be done from ksh file or (if it's possible) from sql developer.
Thx

Comments
Post Details
Added on Mar 16 2021
8 comments
63 views