What is meant by truncate in sql?

0 Answers  

---

What is procedure and function?

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,

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

what is a relationship and what are they? : Sql dba

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

Explain the uses of a database trigger?

0 Answers  

---

What is the difference between local and global temporary table?

0 Answers  

---

What is equi join in sql?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

describe transaction-safe table types in mysql : sql dba

0 Answers  

---

What is rownum in sql?

0 Answers  

---