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

Show code of a cursor for loop.

771

What is nosql vs sql?

869

What are functions in sql?

657

what is a unique key ? : Sql dba

764

how to create a new view in mysql? : Sql dba

685

What are the ddl commands?

718

How do I get sql certification?

702

how many columns can be used for creating index? : Sql dba

673

How do you use a while loop in pl sql?

719

How do I tune a sql query?

725

what is 'trigger' in sql? : Sql dba

726

What pl/sql package consists of?

835

What is normalization in a database?

848

what are the differences between char and nchar? : Sql dba

797

What is the use of sql trace?

672