Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Processing

Post Details

Added on Mar 16 2021
8 comments
385 views