table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

What is substitution variable in pl sql?

0 Answers  

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---

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,

---

how can you see all indexes defined for a table? : Sql dba

0 Answers  

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

What is pl sql architecture?

0 Answers  

---