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