Can two tables have same primary key?

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

---

what is the difference between nested subquery and correlated subquery?

0 Answers  

---

Why we use pl sql?

0 Answers  

---

what is oltp (online transaction processing)? : Sql dba

0 Answers  

---

What is pessimistic concurrency control? : Transact sql

0 Answers  

---

What is auto increment in sql?

0 Answers  

---

What are advantages of Stored Procedures?

3 Answers   Satyam,

---

Can we use commit inside a trigger?

0 Answers  

---

Why does %isopen return false for an implicit cursor?

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

---