Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to construct an SQL query?
Hi,
:) im not making money for this don't worry :) and yes the data is being
retrieved from one table.
I want to make it using PL/SQL?
Thanks.
In article <e9_83.11920$Yr2.178813_at_news2.rdc1.on.home.com>,
"Paul Q" <paulq_at_home.com> wrote:
> I hope your not making money for this Wassim.
> Is the data being being retrieved from one or more tables ?
> In either case as long as you can create the form properly with the
joins
> between the two tables if this is the case.
>
> Oracle will retrieve the appropriate data. By just enter_query and
> execute_query.
>
> Wassim wrote in message <7k1dba$a1m$1_at_nnrp1.deja.com>...
> >Hi,
> >suppose that i have a form like this :
> >name :
> >date : from [ ] to [ ]
> >
> >[send] [cancel]
> >
> >i want to know how to construct the SQL query while i can't be done
only
> >dynamically because criteria of search are only known after
submission
> >of the form, search can be on 'name' only, or 'name'+'from_date' or
the
> >3 criteria..
> >
> >Have i to do it using UNION between 2 or 3 SELECT query?
> >Thanks for help !!
> >
> >Wassim,
> >e-mail: net2000_at_francemel.com
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Jun 14 1999 - 06:12:15 CDT