Answer Posted / sangeetha

create or replace procedure <pocedure_name>(x in number,y
out varchar) is begin
{
executable statements;

}
end <procedure_name>;

exec <procedure_name>(first_parameter,second_parameter);

What is the difference between functions, procedures, and packages in pl/sql?

705

---

What is the difference between a primary key and a clustered index?

697

---

Explain raise_application_error.

830

---

How can the performance of a trigger be improved?

774

---

Can a table contain multiple primary key’s?

806

---

---

What are sql indexes?

740

---

what is primary key? : Sql dba

710

---

Where is pl sql used?

677

---

What are triggers and its types?

755

---

What language is oracle sql developer?

714

---

How do I view output in sql developer?

806

---

How do you truncate?

660

---

What is primary and foreign key?

805

---

Can we use two order by clause in query?

738

---

What is varchar sql?

814

---