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

What are the two different parts of the pl/sql packages?

1141

what is rollback? : Sql dba

1182

What is trigger in pl sql?

1050

How do you explain an index?

1334

What does truncate mean in sql?

1086

Can instead of triggers be used to fire once for each statement on a view?

1006

Can we perform dml on view?

1118

What is delimiter sql?

1060

what is error ora-03113: end-of-file on communication channel?

1229

How to run sql commands in sql*plus?

1255

how do you know the version of your mysql server? : Sql dba

1048

what is sql profiler? : Sql dba

1115

How do I install sql?

1046

How do I pipe the output of one isql to another?

1058

What is a string data type in sql?

1102