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 common use of group by in sql?

1029

Is join and inner join the same?

989

what is cursor. write example of it. What are the attributes of cursor.

1364

Explain sql data types?

1073

What is denormalization in a database?

1028

Does inner join return duplicate rows?

962

How many times can we commit in a loop?

998

Why primary key is required?

984

What is the difference between local and global temporary table?

1024

What is the use of function "module procedure" in pl/sql?

1182

What is the difference between alter trigger and drop trigger statements?

1091

What are transaction and its controls?

1019

What is sorting in sql?

926

Explain clause in sql?

1007

Can we use threading in pl/sql?

1020