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
- 12054 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
What do you mean by “trigger” in sql?
what is bcp? When does it used? : Sql dba
What is sql architecture?
define sql update statement ? : Sql dba
What is the example of procedure?
what are all the different normalizations? : Sql dba
Explain what is a database?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is delimiter sql?
What is rename command in sql?
What is sql injection vulnerability?
What is a sql schema used for?
Does pl/sql support create command?
What is fmtonly in sql?
how can we repair a mysql table? : Sql dba
