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 catalog in Oracle?

0 Answers   MCN Solutions,

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers   IBM,

Explain the use of control file?

0 Answers  

What is meant by a deadlock situation?

0 Answers  

Explain about integrity constraint?

0 Answers  

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

What is a sub query and what are the different types of subqueries?

0 Answers  

What is the max number of columns in an oracle table?

0 Answers  

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,

Will you be able to store pictures in the database?explain.

0 Answers  

How to use "in" parameter properly?

0 Answers