Answer Posted / kumar sudeep

1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

All the above with differences in areas of implementaion
difference as below:
1. Database.
2. Application.

And with ways of implementation differences as below:
1. BEFORE/AFTER.
2. Insert/Update/delete.
3. Statement level/Row level.

Write a sql query to convert all character to uppercase after hypen.

1164

---

What is auto increment feature in sql?

814

---

What is plpgsql language?

711

---

How does join work in sql?

724

---

How do I copy a table in sql?

686

---

---

What is pl/sql language case sensitive?

821

---

What is the syntax and use of the coalesce function?

807

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

719

---

what is the bond code in materialized view?

2675

---

What is nested table in pl sql?

738

---

what is the difference between group by and order by in sql? : Sql dba

757

---

What is memory optimized table?

759

---

What is difference between hql and native sql?

770

---

What are the different type of joins in sql?

717

---

What is the default isolation level in sql server? : Transact sql

740

---