we have a requirement , we need to spool a table data by comma and double quotes separeted.. those output of data needs to load via sqlloader.
if i pass the table name need to spool all column data in above format .
dynamic passing of table name.
Thanks in advance.
use of expdp & impdp would be a better solution.
Why do you want to enclose NUMBER inside double quote marks?
How does above differentiate between numbers & strings?
Check if any of these options going to help you ... using SQL Developer
SELECT /*csv*/ * FROM <yourtable>;
SELECT /*delimited*/ * FROM <yourtable>;
SELECT /*loader*/ * FROM <yourtable>;
SELECT /*fixed*/ * FROM <yourtable>;
SELECT /*text*/ * FROM <yourtable>;