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 is a natural join sql?

920

How many sectors are in a partition?

1031

Is record in oracle pl sql?

902

What are the two types of exceptions in pl/sql?

965

what is difference between delete and truncate commands? : Sql dba

1065

what are dynamic queries in t-sql? : Transact sql

961

When to use inner join and left join?

904

What is sql profiler in oracle?

1013

What is normalization? How many normalization forms are there?

1010

What is an oracle stored procedure?

987

What is varray in pl sql?

1007

Does sql profiler affect performance?

940

what are the different type of normalization? : Sql dba

969

Do prepared statements prevent sql injection?

897

Why should I use postgresql?

970