Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17799 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murthy
Please use the sql loader to upload the file into Oracle
database.
| Is This Answer Correct ? | 3 Yes | 0 No |
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
| Is This Answer Correct ? | 9 Yes | 7 No |
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.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sajid siddiki
Please use sqlldr on UNIX or Ora Loader software to load any
kind of file(txt,xls) into system.
| Is This Answer Correct ? | 1 Yes | 0 No |
yes, We can also import data in db by creating external table.So in this case, we can use sql plus too.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I run sql profiler?
What is the difference between microsoft sql and mysql?
How do I install sql?
What is example of database?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is a view faster than a stored procedure?
What is compilation error in pl sql?
What is latest version of sql?
Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)
What are predefined functions in sql?
How to write html code in pl sql?
difference between table level constraint and column level and advantages of table level constraint
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
