Re: Help ray with his oracle!!

"Daniel Morgan" <damorgan_at_x.washington.edu> schrieb im Newsbeitrag news:1078351617.911959_at_yasure...
> 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)
>

In Forms You could make a button invoking the SQL Loader. I think JDeveloper would be capable, too.

hth, Jan Received on Thu Mar 04 2004 - 05:07:38 CST