How can I make in Oracle an external table with csv enclosed by {}

My external table is now with an csv with {}
OPTIONALLY ENCLOSED BY '{}' doesn't work.

Does any body know how to do this?

Kind Regards,
Silvia OostveenAsked:
Who is Participating?
Gerwin Jansen, EE MVETopic Advisor Commented:
Hi, welcome at EE,

I'm thinking the OPTIONALLY ENCLOSED BY is accepting either one character or this form:


Can you try the above?
Silvia OostveenAuthor Commented:
Thanks this solves my problem.

Kind regards,
Silvia OostveenAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Silvia Oostveen's comment #a40707805

for the following reason:

thats it!
Gerwin Jansen, EE MVETopic Advisor Commented:
You're new at EE, you should close by selecting the comment that answered your question. Now you've chosen your own comment with 0 points, which is not correct.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.