What are the components of a PL/SQL block ?

3 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

How is data stored in sql?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

What is difference between cursor and ref cursor?

1 Answers  

---

what is called after appearing where clause

3 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

Describe types of sql statements?

0 Answers  

---

How many row comparison operators are used while working with a subquery?

0 Answers  

---