Answer / sunil

if use dbms_output.put_line in every retriving value

How can we avoid duplicating records in a query?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What does sign mean sql?

0 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---

What are the syntax and use of the coalesce function?

0 Answers  

---

How many types of literals are available in pl 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 do I start sql from command line?

0 Answers  

---

What is range partitioning?

0 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---