Answer / cm

USE SQL LOADER

Answer / murthy

Please use the sql loader to upload the file into Oracle
database.

Answer / madhu

I NEED PL/SQL PROCEDURE

we can't use sqlplus,why because we can't upload the data
in single statement,So we need pl/sql procedure
or else dump the data using with sql loader

by using command prompt in SQL LOADER

Answer / aryasen

If you are using SQL Developer one option is there for
importing data from excel/csv or any other files.
first u need to create table which contains all columns in
excel. then right click on that table it will give option
for import excel data to the table.

Answer / sajid siddiki

Please use sqlldr on UNIX or Ora Loader software to load any
kind of file(txt,xls) into system.

Answer / abhishekjaiswal

yes, We can also import data in db by creating external table.So in this case, we can use sql plus too.

Answer / yankee

Probably, u have to save the file in ur hard disk(namely in
ur D drive) first eg. sourav.txt
Then open pl/sql developer and open a command window. And
then type in: @ D:\sourav.txt
All the rows will be updated.. finally "commit" it.

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

Explain sql data types?

0 Answers  

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

What are the most important ddl statements in sql?

0 Answers  

diff b/w sub query and co-relater query?

3 Answers   iFlex,

How to get each name only once from an employee table?

0 Answers  

what is the difference between char and varchar data types? : Sql dba

0 Answers  

what is meant by databases

4 Answers  

What is the difference between between and in condition operators?

0 Answers  

What is sql exception?

0 Answers  

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,