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!

Export Data from Oracle table to a .csv file by putting a condition on a column value

MSRMDec 29 2013 — edited Dec 29 2013

Hello gurus,

I have the following data in my table

rowid name version date

1 Oracle 11.1 12/20/2013

2 Java 7 12/10/2011

1 Oracle 12.1 12/28/2013

1 Oracle 10.2 06/12/2010

Now I require a general sql/plsql code for writing columns with a specific value in rowid.

My output should look like

1,Oracle,11.1,12/20/2013

1,Oracle,12.1,12/28/2013

1,Oracle,10.2,06/12/2010

Here I want to pass the value as a parameter dynamically

Can anyone help me with the sql/plsql.

This post has been answered by Frank Kulash on Dec 29 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 26 2014

Added on Dec 29 2013

#cursor

10 comments

685 views