It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
Answer Posted / 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)
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to revoke create session privilege from a user in oracle?
What are oracle functions?
What are the different types of trigger and explain its various uses and functions?
Please explain oracle data types with examples?
What is instant client oracle?
How to call a stored function with parameters?
What is max rowid in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to establish administrator authentication to the server?
20. Using a set operator, display the client number of all clients who have never placed an order.
Explain mutating triggers.
What is recovery manager(rman) backup in Oracle?
What are the types of trigger in oracle?
What is an oracle and why it is used?
How many categories of data types?