Database Administration (MOSC)

MOSC Banner

Question on SQL Developer: how to get ride of quotes for .txt file when exporting query result?

edited Aug 16, 2010 2:03AM in Database Administration (MOSC) 6 commentsAnswered
Hi everyone,

One of the my user has to use Oracle SQL Developerr instead of TOAD. 

In TOAD when you export the query result to .txt file, it gives you something like this:

23       78861          USD           AUG-10            E

However, in SQL Navigator, it give you something like this:

23       78861         "USD"        "AUG-10"         "E" 

Question: how to get ride of the quotes there?

Thanks,

Ning

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center