Re: make Oracle accessable from the web?

[Quoted] How do you create the report so the user can specify the start and end date and be able to use hours and minutes?

[Quoted] 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
Received on Tue Jan 02 2001 - 17:10:01 CET