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

which sql command we can use to get a print out from oracle?

2 Answers   iFlex, INDUS,

How to define a data field as not null?

0 Answers  

what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

What is STATSPACK tool?

3 Answers   Wipro,

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers   BOB Technologies, Cap Gemini, IBM,

What is the use of Control File ?

3 Answers  

What is ordinary table in oracle?

0 Answers   MCN Solutions,

How to recover a dropped index?

1 Answers  

How to get maxsal , minsal, ename department wise in single query

0 Answers  

how to use sequence and what use of sequence cache

1 Answers  

How to export several tables together?

0 Answers  

Why do we need integrity constraints in a database?

0 Answers