How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

using comand prompt how can import table data and table space with example

2 Answers  

---

What are tables and fields in the database?

0 Answers  

---

Why cross join is used?

0 Answers  

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

---

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,

---

What is a memo field?

0 Answers  

---

How many primary keys can a table have?

0 Answers  

---

What are triggers and its uses?

0 Answers  

---

What is oracle sql called?

0 Answers  

---

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

Which is better join or inner query?

0 Answers  

---