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
- 4143 Views
- I also Faced
- E-Mail Answers
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 |
overloading of stored procedure is possible in oracle?
What is the usage of the distinct keyword?
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
Differentiate between sga and pga.
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
What is sql select statement?
How to display the current date in sql?
What is a clob in sql?
What is recursive join in sql?
What is the difference between left join and right join?
Why do we use joins in sql?
query to retrive the employees whose sal is greater than avg sal
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
