What is the use of count (*) in sql?

0 Answers  

---

What is the primary use of normalization?

0 Answers  

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

Which sql statement is used to delete data from a database?

0 Answers  

---

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

What is a native sql query?

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,

---

Explain cursor types?

0 Answers  

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  

---