0

I have a function in my database which retrieves all the columns of a table into a csv file. Now I want to omit only one column and show all the other columns in the result and I do not want to change the function.

How I am retrieving all the columns in to csv file is as following:

CPVCREATECSV := "Function_Name"('table_name') || UTL_TCP.crlf;

after this line, I want to omit only one column and get the rest columns. How to do that? Please help. I am doing it in Oracle.

2
  • I think you are going to have to change the underlying SELECT. Or, just live with a small amount of extra data in your CSV file.
    – Tim Biegeleisen
    Commented Jul 17, 2017 at 7:27
  • 2
    You have three options: 1. Change the function to include a list of the columns you wish to select, 2. Write some code (in Oracle or - better - outside of Oracle) to parse the file to remove the column you don't care about or 3. Have a manual step that involves opening the file in Excel, and the removing the column you don't want.
    – Boneist
    Commented Jul 17, 2017 at 7:28
Related questions
677
Fetch the rows which have the Max value for a column for each distinct value of another column
219
How can I get column names from a table in Oracle?
318
How do I find duplicate values in a table in Oracle?
Load 7 more related questions Show fewer related questions

0

Reset to default

Browse other questions tagged or ask your own question.