Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4083 Views
- I also Faced
- E-Mail Answers
Answer Posted / pravellika
create or replace procedure check1 (num number)
is
cursor c1(id number) is select b.a,b.city,b.code from (
select instr(id,code,1,1) as a,city,code from t1 )b
where b.a=1;
v_id number;
v_code NUMBER;
v_city VARCHAR2(100);
begin
open c1(num);
loop
fetch c1 into v_id,v_city,v_code;
exit when c1%notfound;
dbms_output.put_line(v_city||' '||v_code);
end loop;
close c1;
end;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does mysql_real_escape_string prevent sql injection?
Explain the advantages and disadvantages of stored procedure?
What is a file delimiter?
How can you save or place your msg in a table?
How many triggers can be applied on a table?
What is the difference between the sql*loader and import utilities? : aql loader
What is sql stand for?
What does sign mean sql?
What steps server process has to take to execute an update statement?
How do you concatenate in sql?
What is cursor explain with example?
Why query optimization is needed?
What is sql partition function?
explain commit and rollback in mysql : sql dba
What is the difference between union and union all command?
