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
12049 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 unique keys be null?

910

What do you understand by pl/sql packages?

1058

Why should I use postgresql?

1015

What is the example of procedure?

928

what is top in tsql? : Transact sql

1118

how to decrement dates by 1 in mysql? : Sql dba

1019

What are pl sql procedures?

1025

What does desc stand for?

1070

what are all the different normalizations? : Sql dba

1041

Does google use sql?

960

what is the functionality of the function htmlentities? : Sql dba

962

how to get @@error and @@rowcount at the same time? : Sql dba

1027

What is materialized view in sql?

920

What are all types of user defined functions?

1073

Is sql procedural language?

967