Interested to Buy Any Domain ? << Click Here >> for more details...
how to give permission to users that users can
update/insert/delete on a row of table on timeing 10am to
6pm only?
- 4 Answers
- 12231 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pariksheet de
Grant Insert,Update,Delete
On Employees
To All
-----------------------------------------------
Create Trigger Upd_Employees
Before Insert,Update,Delete on Employees
For Each Row
Begin
if to_char(sysdate,'Dy') in
('Mon','Tues','Wed','Thrs','Fri','Sat','Sun') and to_char
(sysdate,'hr:mi') not between ('10:00') and ('6:00')
then raise_application_error(-
20145,'Insertion/Updation/Deletion can take place between
10:00 am and 6:00);
end if;
end;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
explain what is mysql? : Sql dba
What are the different schemas objects that can be created using pl/sql?
how to include numeric values in sql statements? : Sql dba
How many sql databases can you have on one server?
Is sql microsoft?
I need a function for a train ticket reservation please answer it thanks in advance
What can sql server reporting services do?
What is t sql in sql server?
Why are indexes and views important to an organization?
How to get each name only once from an employee table?
Give the order of sql select?
What is left join in postgresql?
what is a control file ? : Sql dba
Is nosql faster than sql?
How will you distinguish a global variable with a local variable in pl/sql?
