Answer / rajesh venati

Yes, we can use global variables in procedure and functions.

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,

---

What is pl sql architecture?

0 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

What are the advantages of sql?

0 Answers  

---

---

What is a file delimiter?

0 Answers  

---

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

---

What are the pre requisites?

1 Answers  

---

What are the steps for performance tuning.

0 Answers  

---

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

---

Does group by remove duplicates?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---