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;

explain normalization concept? : Sql dba

1030

---

How can you view the errors encountered in a trigger?

945

---

Can we alter stored procedure?

967

---

What does subquery mean in sql?

1034

---

Explain alias in sql?

1027

---

When sql appeared?

1070

---

What is cursor status?

1176

---

Why function is used in sql?

924

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7264

---

What is the main reason behind using an index?

1001

---

Which command is used to delete a package?

1148

---

differentiate between float and double. : Sql dba

1036

---

give the syntax of grant and revoke commands? : Sql dba

1136

---

How many row comparison operators are used while working with a subquery?

1016

---

Can we use ddl statements in stored procedure?

1129

---