What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---

what is rollback? : Sql dba

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 autocommit sql?

0 Answers  

---

How to rename a table?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

How to convert ms-excel file to oracle table?

2 Answers  

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

---

How do you retrieve the last N records from a table?

10 Answers  

---

What are the sql versions?

0 Answers  

---

What is rollback?

0 Answers  

---