When I Export Data to a Delimited Text as the output option, the resulltsfail to returnthe standard .csv delimiters of a comma and double quotes.
For example, the .csv export from the EMP table:
7369SMITHCLERK790217-Dec-198080020
7499ALLENSALESMAN769820-Feb-1981160030030
7521WARDSALESMAN769822-Feb-1981125050030
7566JONESMANAGER78392-Apr-1981297520
7654MARTINSALESMAN769828-Sep-19811250140030
7698BLAKEMANAGER78391-May-1981285030
7782CLARKMANAGER78399-Jun-1981245010
7788SCOTTANALYST756619-Apr-1987300020
7839KINGPRESIDENTNAN17-Nov-1981500010
7844TURNERSALESMAN76988-Sep-19811500030
7876ADAMSCLERK778823-May-1987110020
7900JAMESCLERK76983-Dec-198195030
7902FORDANALYST75663-Dec-1981300020
7934MILLERCLERK778223-Jan-1982130010
WORKAROUND:
Alter the the options screen and select a different delimiter for each value and then re-select the default comma and double quotes, the the delimited file is generated properly.
STATUS:
Issue fixed in version 6.3. The latest version of SQL Navigator for Oracle can be downloaded here.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy