how to give permission to users that users can
update/insert/delete on a row of table on timeing 10am to
6pm only?
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 |
Post New Answer View All Answers
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are the advantages of sql?
What do you understand by pl/sql cursors?
What is trigger in pl sql with examples?
What is the non-clustered index in sql?
How to read/write files from pl/sql?
Can a foreign key be null?
What is the use of sqldataadapter?
What is sql select statement?
What is pl sql in oracle?
How do I count duplicates in sql?
Is sql similar to python?
What's the difference between a primary key and a clustered index?
Which normal form is best?
what is the difference between nested subquery and correlated subquery?