create or replace trigger trig_aone before insert or update or delete on a

how to give permission to users that users can
update/insert/delete on a row of table on timeing 10am to
6pm only?

Question Posted / kart

4 Answers
11993 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

Please Help Members By Posting Answers For Below Questions

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1031

How many databases can sql express handle?

964

what are integrity rules?

1006

What are operators available in sql?

1023

Can we alter stored procedure?

967

define sql insert statement ? : Sql dba

1007

Which join is like an inner join?

1007

List the ways to get the count of records in a table?

893

What is difference between stored procedures and application procedures?

993

what is column? : Sql dba

986

What is oracle sql called?

897

What is data definition language?

1080

What is the importance of sqlcode and sqlerrm?

1329

Is sql developer case sensitive?

978

Is a table valued function object?

994