Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

What will you get by the cursor attribute sql%notfound?

0 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

What does count (*) mean?

0 Answers  

---

what is dbms? : Sql dba

0 Answers  

---

define data blocks ? : Sql dba

0 Answers  

---

how can we find the select statement is indexed or not?

3 Answers   CTS,

---

Is sql microsoft?

0 Answers  

---

How run sql*plus commands that are stored in a local file?

0 Answers  

---

what is meant by tuning and tk proof?

2 Answers  

---

How pl/sql source code can be protected?

3 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,

---