Answer Posted / swapnareddy

Declaration Block(optional)
Begin
Executable Block
exception Block(optional)
end;

How to get help at the sql prompt?

827

---

What are aggregate and scalar functions?

719

---

What is %type in pl sql?

702

---

Differentiate between syntax and runtime errors.

839

---

Can we update views in sql?

684

---

---

Can we create a trigger on view?

663

---

What is trigger and how to use it in sql?

723

---

What is normalization in sql?

709

---

Is not null in sql?

727

---

How to process query result in pl/sql?

770

---

What is the use of primary key?

729

---

how to check server status with 'mysqladmin'? : Sql dba

779

---

How subquery works in sql?

725

---

Do ddl statements need commit?

724

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

760

---