Answer / mk

An extent is a contiguous set (side-by-side) of Oracle data blocks allocated to a segment within a tablespace.

Is sql port 1433 encrypted?

0 Answers  

---

Which one is faster ienumerable or iqueryable?

0 Answers  

---

differentiate between float and double. : Sql dba

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

Can there be 2 primary keys in a table?

0 Answers  

---

What is Difference between StoredProcedure and function?

3 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

Are stored procedures faster than dynamic sql?

0 Answers  

---

What is string data type 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,

---

What is dbo in sql?

0 Answers  

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---