Answer / bikash khuntia

Import both types whether .xls or .txt into Oracle table by
sql loaded with Control file. We can load large no. of
records in few seconds.

Thanks

Answer / venkat

Create a DSN for ORACLE DRIVER AS TEST THROUGH ODBC

OPEN THE EXCEL FILE IN ACCESS FILE

EXPORT INTO THE TABLE THROUGH DSN(oDBC)

Answer / amit

Thanks Kiran & Hima and sory for let reply.
Actully I want to Import data from SQL server to
Oracle. in that database some files are in .jpg format
means image format is there any query to import data from
SQL server to Oracle.

Answer / hima bindu

Hi
If u want to import the data which is in .xls file to
oracle data base then first create temporary table in
database then write insert statements in excel file using
functions then execute that scripts into toad. Then the
data in excel sheet is imported to data base.

Answer / 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

What is a static data dictionary in oracle?

0 Answers  

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 Answers  

Explain what are the type of synonyms?

0 Answers  

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

How to divide query output into groups in oracle?

0 Answers  

How to count duplicated values in a column in oracle?

0 Answers  

What are oracle functions?

0 Answers  

How to bring a tablespace online?

0 Answers  

How to find 1st, 2nd, 3rd highest using select select statement not using rownum

3 Answers  

What is flashback Query ? And Use ?

4 Answers   Thermotech,

How many data types are supported?

0 Answers  

What is oracle join syntax?

0 Answers