Answer / Dheeraj Kumar Singh

"PL/SQL supports three types of triggers: DDL (Data Definition Language) triggers, DML (Data Manipulation Language) triggers, and DBMS_EVENT triggers. Each trigger type is designed to respond to specific database events."n

What are field types?

1 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What is delimiter in pl sql?

1 Answers  

---

What is the use of non clustered index?

1 Answers  

---

what is a tablespace? : Sql dba

1 Answers  

---

what's the difference between a primary key and a unique key? : Sql dba

1 Answers  

---

Which data type doesn't allow null data type?

6 Answers   TCS,

---

What are the types of join in sql?

1 Answers  

---

What are %type and %rowtype for?

1 Answers  

---

How do I run a sql script?

1 Answers  

---

Explain architecture of sql server notification services?

1 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---