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 are the authentication modes in sql server? How can it be changed? : Sql dba
Explain how to use transactions efficiently : transact sql
What is view explain with example?
What is a composite primary key?
How do you write an inner join query?
What are the types of records?
What is the purpose of design view?
what is a record in a database ? : Sql dba
Why is sql*loader direct path so fast?
What is the difference between a primary key and a unique key?
what is cursor. write example of it. What are the attributes of cursor.
How to sort the rows in sql.
What is sqlservr exe?
What is the purpose of the primary key?
What is the difference between a primary key and a clustered index?