Answer Posted / sudhir kumar singh

procedure_name(a in number,b out varchar)
(
script of execution;

)
exec procedure_name(first_parameter,second_parameter);

What is memory optimized table?

662

---

What are the different set operators available in sql?

655

---

What is the purpose of cursors in pl/sql?

715

---

Is it possible to update views?

621

---

What is the need of a partition key?

624

---

---

What is linq to sql?

659

---

How insert into statements in sql?

690

---

explain the advantages and disadvantages of stored procedure? : Sql dba

611

---

What is oracle sql developer?

686

---

What will you get by the cursor attribute sql%notfound?

688

---

What is package in pl sql with an examples?

628

---

How many triggers can be applied to a table?

695

---

How to read/write files from pl/sql?

666

---

How do I edit a trigger in sql developer?

623

---

What are the different ddl commands in sql?

652

---