Re: limit the time
From: Michael Kuznetsov <mvk_at_servocomp.ru>
Date: 30 Jul 2002 02:24:27 -0700
Message-ID: <1543a3e7.0207300124.71e36c2d_at_posting.google.com>
Date: 30 Jul 2002 02:24:27 -0700
Message-ID: <1543a3e7.0207300124.71e36c2d_at_posting.google.com>
Hi Andrew,
You can create view like this:
select ename from emp
where to_number(to_char(sysdate, 'hh24')) >=8 and
to_number(to_char(sysdate, 'hh24')) <= 16
User could select date from this view from 8:00am to 4:59pm. In other time he couldn’t get any rows.
Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com
"Andrew Wong" <andrew_at_i-cable.com> wrote in message news:<ai471v$n3o3_at_rain.i-cable.com>...
> If I create a view based on table employee,
> how should I limit the view only can be accessible between 8.00am to 5.00pm?
Received on Tue Jul 30 2002 - 11:24:27 CEST