It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
Answer Posted / kiran kumar
open the TOAD and run the QUERY by using the SELECT
statement. after that click the right button and select the
SAVE AS button, in that select .xls Radio button and enter
the file name automatically data store in that file
| Is This Answer Correct ? | 4 Yes | 29 No |
Post New Answer View All Answers
What is open database communication (odbc) in oracle?
Can the query output be sorted by multiple columns in oracle?
what are archived logs?
What are the differences between char and varchar2 in oracle?
Design database draw er diagram for a certain scenario ?
How to create a temporary table in oracle?
How to define a data field as not null?
what happened to the global index when I truncate the data in one of the partition?
Explain an extent?
What is a cursor and what are the steps need to be taken?
What are the varoius components of physical database structure of oracle database?
Will you be able to store pictures in the database?explain.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How do I spool to a csv formatted file using sqlplus?
Can sub procedure/function be called recursively?