How to select unique records from a table?

0 Answers  

---

what is the bond code in materialized view?

0 Answers  

---

What does subquery mean in sql?

0 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---

what is the difference between ereg_replace() and eregi_replace()? : 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,

---

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

Explain clause in sql?

0 Answers  

---

What is the execution plan in sql?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

What is sqlcontext?

0 Answers  

---