I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS
- 7 Answers
- 15749 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 14 No |
Post New Answer View All Answers
what is 'trigger' in sql? : Sql dba
What is normalization in a database?
What is sql query limit?
Does a primary key have to be a number?
How do you use a while loop in pl sql?
Do we need to create index on primary key?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is the current version of sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
How do I pipe the output of one isql to another?
How do you copy a table in sql?
Is sql easier than java?
How do you create a unique index?
What is difference between sql and mysql?
What is a temporal data type?
