Skip to Main Content
Forums

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!

concatenate issue in the middle character with Quoted mark

Rajesh123Sep 11 2018 — edited Sep 11 2018

Hi All,

I have a column data in the table.

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

WITH table_x

 AS (SELECT 'Hot "N" Fresh, Inc.'           party\_name,

            'Hot "N" Fresh-C/C-PO Box 7437' party\_desc

     FROM   dual)

SELECT '"'||party_name ||'"'||','

 ||'"'||party\_desc ||'"'

FROM table_x

Developed SQL PLSQL package to get txt output and i will chnage this to .csv file.

dbms_output.put.line('Party Name',' Party Description' )

dbms_output.put.line('"'||party_name ||'"'||','||'"'||party_desc ||'"' );

I am getting output like below.

pastedImage_8.png

Expected output:

pastedImage_9.png

Could you please help me?
This post has been answered by mNem on Sep 11 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2018
Added on Sep 11 2018
7 comments
818 views