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: more than a one result set at the same time

Re: more than a one result set at the same time

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 21 Mar 2007 04:54:31 -0700
Message-ID: <1174478071.041148.57780@b75g2000hsg.googlegroups.com>


On 20 mrt, 21:09, "Mariano" <mariano.calan..._at_gmail.com> wrote:
> On 20 Mar, 20:34, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
>
>
>
> > Mariano schreef:
>
> > > I really don't know where to post this message, but usually I post
> > > here...
>
> > > Then...
> > > I would know, thinking in abstract level, so with no specific database
> > > or specific programming language, in your opinion: is it possible use
> > > 2 or more "ResultSet" to complete my work?
>
> > > For example: I have a set of box to fillup with data obtained from a
> > > DB, one of this box is a Menu/List item (the component with down
> > > arrow) , in this menu appear a list of date (also date must be read
> > > from DB). By the click of one of this data, some box of the set must
> > > be changed.
>
> > > My question is: should I have two query/Result set:
> > > 1) a rs that give a list of date, that will fill up my Menu Field
> > > 2) a rs that give all information of a specific date (this date will
> > > be decided by Menu Field)
> > > ???
>
> > > I hope that I've been not so incomprehensible :D
>
> > Sounds like *two* resultsets to me.
> > Oracle can handle those requests rather efficient, by using bind
> > variables - that is, your statement does not change from an
> > Oracle perspective:
> > select * from date_info_table where date_id = :1;
>
> > The *value* of :1 changes, not the statement.
>
> > The java approach would be to select all from date_info_table,
> > store that on the application server, change the java runtime
> > parameters into -MX1024 -MS256 or similar, and shrug when the
> > sysops start complaining about memory usage of those darn Java
> > apps...
> > The date info you would need to display would be sorted, hashed,
> > washed, rinsed and dried on the application server before it is
> > actually displayed.
>
> > All this because of performance.
>
> > Yes, I've had a bad day; sysops refused to create any packages,
> > as all 32(!) servers were running 100% CPU and swapping...
> > --
> > Regards,
> > Frank van Bortel
>
> > Top-posting is one way to shut me up...
>
> yes, bind variables is the solution. Now... if I don't wanna do
> complicated operations on server, the last remaining solution is to
> make a query to fillup List with date, and another query (with bind
> variables) to obtain info from the fields with selected date, right???

Yes - don't know what front-end you use, but in forms you would use a when-item-changed event. In that event, you would fetch youe date details, based on the date selected in the box.
HTML would need java(script) Received on Wed Mar 21 2007 - 06:54:31 CDT

Original text of this message

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