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
- 17787 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
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 sql easier than java?
What is group function in sql?
What is a boolean in sql?
What is data type in sql?
What are the different ways to optimize a sql query?
What is graph sql?
How do I partition a table in sql?
What information is needed to connect sql*plus an oracle server?
What is t-sql? : Transact sql
Can a select statement fire a trigger?
Are null values same as that of zero or a blank space?
What are stored procedures in mysql?
How to load data with sql*loader?
what are the types of subquery? : Sql dba
