What is the importance of sqlcode and sqlerrm?

0 Answers  

---

four procedures is are there should i write their in a package

2 Answers  

---

What is a function in oracle pl sql?

0 Answers  

---

What is data profiling in sql?

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

---

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 program debugging?

0 Answers  

---

Can a composite key be null?

0 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

Write an sql query to select all records from the table?

0 Answers  

---

What is the use of primary key?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---