Convert oracle table data into excel sheet - oracle

Can you explain how to convert oracle table data into excel sheet?

There are 2 ways to do so:

1. Simply use the migration wizard shipped with Oracle.
2. Convert Excel sheet into CSV file. Create an oracle table, and use SQLLoad to load the CSV file into the oracle table.

E.g.:
load data
infile MySheet.csv
replace
into table mytable
fields terminated by ','
(name,age,salary)
When should we go for hash partitioning? - oracle
Hash partitioning - Scenarios for choosing hash partitioning: Not enough knowledge about how much data maps into a give range...
What is Materialized view? What is a snapshot? - oracle
Materialized view and snapshot - A materialized view is a database object that contains the results of a query. A snapshot is similar to materialized view...
Advantages of running a database in NO archive log mode - oracle
NO archive log mode - 1. Less disk space is consumed 2. Causes database to freeze if disk gets full...
Post your comment

Related Content

Follow us

▲