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
- 11272 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 dbms? What are its different types?
What are the most important ddl statements in sql?
What are the query optimization techniques?
Show how functions and procedures are called in a pl/sql block.
How do I delete a trigger?
What are the different types of joins in sql?
how to fetch alternate records from a table? : Sql dba
What is dml statement?
What is an inconsistent dependency?
How do you go back in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What does sql stand for?
What are local and global Indexes and where they are useful.
explain mysql aggregate functions. : Sql dba
