We have to create trigger create trigger trg

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 / hari

Answer Posted / hari

We have to create trigger

create trigger trg_name
before insert/delete/update on table
when sysdate between 10am to 6pm
begin
logic
end;

Is This Answer Correct ?

13 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1129

is mysql query is case sensitive? : Sql dba

1162

Does inner join remove duplicates?

992

How do I write a cron which will run a sql query and mail the results to agroup?

1029

What is a left join?

1006

Does a user_objects view have an entry for a trigger?

1049

What is primary key and foreign key?

1010

what are all the different types of indexes? : Sql dba

1103

how to convert dates to character strings? : Sql dba

1249

How many rows can sqlite handle?

1160

What are reports usually used for?

1080

Why do we use joins?

1097

What is native sql query?

1074

Is foreign key mandatory?

1064

how to get a list of all tables in a database? : Sql dba

1028