vj wrote:
Could anyone help me with the option which I need to include in a
export statement which would avoid the quotes " in the output for
columns with Data Type as String.
You can use characters other than a quote (") by using the CHARDEL
filetype modifier, as in:
export to x.del of del modified by chardel< select * from table
Which results in strings like <Hello< (instead of "Hello").
I don't think you can eliminate the character delimiters without
coding a manual select (select col1 || ',' || col3 || ',' ...) -
they are essential in differentiating between a zero-length string
and a NULL.