how to give permission to users that users can
update/insert/delete on a row of table on timeing 10am to
6pm only?
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
What is sqlcommand?
Why truncate is faster than delete?
What will you get by the cursor attribute sql%rowcount?
What are the two types of exceptions.
What does t sql mean?
Write the command to remove all players named sachin from the players table.
How is a process of pl/sql compiled?
How do I run a script in sql developer?
What is the requirement of self-join?
Is join and inner join the same?
What is the purpose of a secondary key?
Is it important to partition hard disk?
How many types of privileges are available in sql?
What are analytical functions in sql?
What is schema in sql example?