How to export data with a field delimiter?
- 1 Answers
- 1113 Views
- I also Faced
- E-Mail Answers
Answer / Satendra Pratap Singh
To export data from Oracle with a specific field delimiter, you can use the 'export' utility. For example, to export a table named 'mytable' with comma-separated values (CSV), you would run:nn$ exp mytable/mypassword@mydatabase file=mytable.csv fields=wnReplace 'mypassword' and 'mydatabase' with your actual password and database name. The 'fields=w' option specifies CSV format.n
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different types of databases?
What is Redo Log Buffer in Oracle?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
what is the syntax of CREATE command?
What is a Segment ?
Where are the settings stored for each instance in oracle?
How to create an oracle testing table?
How to get a create statement for an existing table?
Define 'view' advantage ?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What are a cluster and non-cluster index?
How to initialize variables with default values?
Oracle General 
