Answer Posted / kirankumar.vangeti

create or replace procedure procedure_name as

Declare
/* Declarative section: variables, types, and local sub
programs */
Begin
/* Executable section: Procedural and sql statements go
here */
Exception
/* exception handling section: error handling statements go
here */
End;

Why join is faster than subquery?

804

---

Explain raise_application_error.

845

---

What are the sql commands?

809

---

What does cursor do in sql?

725

---

Can we call dml statement in function?

776

---

Can you rollback after commit?

731

---

Why do we use sql constraints?

877

---

Can we call procedure in select statement?

742

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

881

---

What is a recursive join sql?

825

---

How do I enable sql encryption?

725

---

What is substitution variable?

807

---

What is coalesce sql?

715

---

what are the different type of normalization? : Sql dba

771

---

What is sql procedures and functions?

760

---