Answer / krina

we can execute multiple sql statement inside the procedure

Answer / gourav joshi

hi,
For eg u want to insert 3 data at a same time so u can use
annonyoums block for eg emp_id,Name,Salary u want to insert
data in a table u can use this annoynomous blck

Begin
Insert into table name values(1, 'gourav',2000);
Insert into table name values(2, 'joshi',6000);
Insert into table name values(3, 'ram',4000);
end;

then execute

What are instead of triggers?

0 Answers  

---

How many unique keys can a table have?

0 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

---

What are analytic functions in sql?

0 Answers  

---

How many columns should be in an index?

0 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

What is a database? Explain

0 Answers  

---

..........refers to the disk mirroring

2 Answers   iFlex,

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

---