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

What is the difference between view and stored procedure?

1001

What are the features of pl sql?

1110

What is #table in sql?

1182

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1132

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

1034

What is the use of double ampersand (&&) in sql queries? Give an example

1189

What is the difference between local variables and global variables?

1175

How many aggregate functions are available there in sql?

1018

What is coalesce in sql?

1131

Is null operator in sql?

1092

What does fetching a cursor do?

1133

List different type of expressions with the example.

973

What is percent sign in sql?

1324

How do I view a procedure in sql?

1019

Why do we need pl sql?

1037