Interested to Buy Any Domain ? << Click Here >> for more details...
How to export the table data (this table having 18 million
records) to .csv file. Please tell me is there any faster
way to export the data.
- 8 Answers
- 34368 Views
- I also Faced
- E-Mail Answers
Answer Posted / maumita bandyopadhyay
We can use External table to extract data from data base
to .csv file. External table of TYPE ORACLE_DATAPUMP will
do.
Syntax is:
CREATE TABLE <ext_table_name>
ORGANISED EXTERNALLY
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY <directory_name>
LOCATION <filename.dat>
)
AS SELECT * FROM <internal_table_name>
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is mutating error?
How do you select unique values in sql?
What is the difference between delete and truncate commands?
What is date functions?
What is a natural join?
Why do we need view in sql?
Which constraints we can use while creating database in sql?
What is the non-clustered index in sql?
What is scalar function?
What is crud sql?
Enlist some predefined exceptions?
How do you truncate?
What is the current version of sql?
what are different types of keys in sql?
What is difference between table and view?
