[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

IMPORTING BULK DATA

Posted on 2013-12-23
3
Medium Priority
?
352 Views
Last Modified: 2014-01-08
Hi Experts

I have a problem

I want to have a button so that when it is pressed it imports student_no,arriving_time,leaving_time and supervisor_name from the excel/CSV file.

Please help, how do I go about?


Thank you in advance
0
Comment
Question by:hinamansoor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Accepted Solution

by:
Praveen Kumar Chandrashekatr earned 1000 total points
ID: 39737889
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39739739
try to use the sqlloader as mentioned above to do the bulk loading of the data. if you think for sure that you have hit a problem using sqlloader and that cannot be resolved, then try the alternate option of using utl_file package as that requires some programming effort from you/your team right.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 39742726
With Oracle Forms6i running in client/server mode (as you told us in another recent question) if you want Forms to load data from either an Excel or *.csv file, that file must be located on the client computer (or on a network drive that is accessible from the client computer).  You normally cannot use a file on the database server computer for this (unless you have a directory there that is shared with the clients).  Also, you normally cannot use SQL*Loader (which is a server-side utility) or UTL_FILE (which is also a server-side program).  

But Oracle Forms supports the FILE_IO utility to read or write from files on the client PC.  You can use this Oracle Forms built-in (FILE_IO) to read the Excel or *.csv file, then use PL\SQL logic in Oracle Forms to process the data from the file.  This is easy with *.csv or *.txt files.  I have never done this with Excel files and Oracle Forms.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question