Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / lizamishra15


table :- city name country code abc 11 bcd 22 cde ..

Answer / 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

More SQL PLSQL Interview Questions

What is a .db file?

0 Answers  

How do I run a program in pl sql?

0 Answers  

how will u find statistics of a database objects?

2 Answers   iFlex,

What is assignment operator in pl sql?

0 Answers  

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

What is the default value of CHAR type?

3 Answers   Bosch,

How do I count records in sql?

0 Answers  

What is pl sql in dbms?

0 Answers  

What is materialized view. What are different methods of refresh?

0 Answers  

Can we create table in function?

0 Answers  

Can a table contain multiple foreign key’s?

0 Answers  

which types of join is used in sql widely? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories