Re: make Oracle accessable from the web?

Mark wrote:
>
> How do you create the report so the user can specify the start and end
> date and be able to use hours and minutes?
>

I posted too quickly before - sorry.
You need to have host variables in the SQL - The software parses the sql and gives you a page where you set up prompts, etc, etc for the input variables if there are any - e.g.

an SQL statment in the report containing this:

WHERE C1_START > to_date(:start_date,'dd-mon-rr hh:mm') AND C1_END < to_date(:end_date,'dd-mon-rr hh:mm');

would then give you a column formatting page for start and end dates.

I had some trouble and had to use TO_CHAR with date masks to get params into the query but it can be done.

> Your example is a specific sql statement that does not allow for a
> user to input the dates of interest.
>
> Mark
>
> On Tue, 02 Jan 2001 09:10:31 +0000, Xifer <ark_at_im.net> wrote:
>
> >Mark wrote:
> >>
> >> I have an Oracle Database. I need to allow people to run queries on
> >> the database using a web browser. The web page would allow the user
> >> to specify a beginning date and an ending date and the query would
> >> return the data. I have Webdb, but it can not query on columns that
> >> are of type DATE when the dates you are searching with use hours and
> >> minutes.
> >
> >
> >Yes it can. e.g.
> >
> >[...] WHERE start_date < trunc(sysdate) + 1100/1440
> >and end_date > trunc(sysdate) + 22/24 ;
> >
> >RTM

-- 
"No man is happy without a delusion of
 some kind. Delusions are as necessary to
 our happiness as realities."