Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help ray with his oracle!!

Re: Help ray with his oracle!!

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 4 Mar 2004 12:07:38 +0100
Message-ID: <c272ru$1p7cvg$1@ID-93924.news.uni-berlin.de>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US