Re: Help ray with his oracle!!

Ray Godfrey wrote:

> i was wondering how to load a notepad file into a database with the
> click of a button on a jsp frontend. the notepad would have a list of
> people and their required attributes eg. ('543210', 'MARY', 'Earl',
> 'home', 'Place', 'JOSEPH');

There are at least a half-dozen different ways. As you told us almost nothing about the application I can't tell you which is best. In fact, you didn't even tell us the version of Oracle.

Myself ... I would use an external table or UTL_FILE but many other approaches are possible.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)