?
Solved

IMPORTING BULK DATA

Posted on 2013-12-23
3
Medium Priority
?
350 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

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

771 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