how to give permission to users that users can
update/insert/delete on a row of table on timeing 10am to
6pm only?
- 4 Answers
- 11265 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kart
create or replace trigger trig_aone
before insert or update or delete on aone
for each row
begin
if to_char(sysdate,'HH24') not between (9) and (18) then
raise_application_error('-20011','u cant update in business
time');
end if;
end;
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How do I save a sql query?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What are triggers in sql?
What is the sql*loader? : aql loader
What are the most important ddl statements in sql?
What does the file extension accdb stand for?
What is the difference between in and between in sql?
how to get @@error and @@rowcount at the same time? : Sql dba
How do I view output in sql developer?
What is clause?
What is left inner join in sql?
Define implicit and explicit cursors.
How many row comparison operators are used while working with a subquery?
What is rownum in sql?
What is primary and foreign key?
