Oracle Database Discussions

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 Using Escape Character

946997Jul 2 2012 — edited Jul 2 2012

Hi All

I have got a requirement where i need to export data from oracle with escape character.
eg. I am using a delimiter 237(í) and if the same character is present in data it should be escaped by escape character eg. /.

Once this file will get created i need to load this file in Netezza database which supports escape character.

Data in oracle table
FirstName Lastname Designation
abc xyz mnz
def ghío pqr

Data should be exported like below
FirstnameíLastnameíDesignation
abcíxyzímnz
defígh/íoípqr

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2012

Added on Jul 2 2012

#export, #general-database-discussions

3 comments

1,353 views