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
11888 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

Can we use distinct and group by together?

989

how to convert numeric values to character strings? : Sql dba

1034

How does sql developer connect to oracle database?

949

Difference between global and parameter variables?

1905

What do you understand by pl/sql cursors?

1015

Is subquery faster than join?

950

Can we use ddl statements in stored procedure?

1094

Why function is used in sql?

877

How do I view a procedure in sql?

906

How do I order columns in sql?

907

How do you update a table in sql?

921

what is the difference between primary key and unique key? : Sql dba

968

How many postgresql users are there, worldwide?

989

Is sql a oracle?

911

What is sap sql?

928